Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vLXeL-002qZE-2u for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 02:10:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vLXeK-009rVc-1M for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 02:10:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vLXeK-009rVU-0P for pgsql-hackers@lists.postgresql.org; Wed, 19 Nov 2025 02:10:24 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vLXeI-000HRV-0r for pgsql-hackers@lists.postgresql.org; Wed, 19 Nov 2025 02:10:24 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-88056cab4eeso47364466d6.2 for ; Tue, 18 Nov 2025 18:10:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1763518220; x=1764123020; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=VkNLvLDxCLD6QjtW/6DH9eBH/0usCNtAS70e5sABNCE=; b=NA7B797QhqmsTcX4JPovUGwf2EvZPNtJIMm4x6aqmJqZdjxzOJoEh4fQaDWlwUnbi0 ni9Ojp02P/eYa9ooV7/Ar4IqQQjasH9uP66+D+hxS1zwkEcBwkEErxhh5pzL9FNonrva dxvMrKDeq8Wucw0gUSi3oEHBFBZERmWVCbXip+XPaGdX/rIITvvN68Jw44Q+effNiCoz aiITzLuyHlowrM8rNqIYfms3Eamlu3R+80p9ss4wQDk/hI/MpY+rI49eVJB4dFx24rzL ncr5Vxo5Qlks9yoiH/ljLDWJVyfLvjn53XKKY49ZMB0rA1JUZGoJleV5hWuInW5ITTuD GifA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1763518220; x=1764123020; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=VkNLvLDxCLD6QjtW/6DH9eBH/0usCNtAS70e5sABNCE=; b=TBKETI4Z37O0fHUsujXbJbnMfT0UXHJX/fgzJkczthYmHsh6zqoO0PWrFxmnz9TKJi dv/9qTz9cOf0b9eiNjrmBnzcHfU7ARG+IiAen2mmQ26vpupAZaF1yw69SahTIEPu7r0B +AwBmygEQpBeLYnug2UMI+YQu5OPVfmx21JrNFayzF539DmHvxAwKlMpqPlxmGdp+J3y mJAlWSwHlAfXK25YuXjCOTUyWDUKWNYqNdW6SgNg2NCvx42FFAn2hlUYQO0LPGzl/egj jB5C8NhVkY6OBvbg0z2ta1CkRbXP8VYU4/+nXW0pHI8Srp2lEKSb4nykmK7xR+mXeHjI jxsA== X-Forwarded-Encrypted: i=1; AJvYcCW77l48g5trluyAfWPn1BF7Xz8UecH5tK2Bg1Drcu9atFPd2MBzeTzwjyaVoLwDu+FAnZL42GDFUPY+zj56@lists.postgresql.org X-Gm-Message-State: AOJu0Yy+77RRf7MDPVrInuyfFPYtQrsYUwi0pRHFb1h4dr976h7GhuaE hGwkDj7ufO8ELTCEgt2C1MFGKp/66XEN4+GILdsONoLtb5po+oCQTcPI X-Gm-Gg: ASbGncvp9s69/K5aHSyFefAJTtd3vLMYmy46SPNzkprBGRzxTb7c258D9Ps3pMkc1UI CB7rxt1K1uJoyv1A/n0Yx8sympilrNVcumwkWFa2fXRQWT1t9llYD57dfSJx77lSIJ4/I5arTuy Ezh4w0r2hLKwInbvfEKJ59eWjMk8SpwN5f29D3twNjZ/I57lbWEnkb0gVMW0pNuZYjAG/JCxm/Q PlYq9hIomvYxlEsfaeI7Vkdp3OMg33EzTTq1VSu+w+86tSXhfx0lDwGTTAlHOqjPE8iL/H5te25 WxfedwPdrFB57XNM3fFaVGgQAV9C2BVXrBe/xYYVYMEg813vHy7rGZSfnHbmTMHYa2iuN846MMj bLJgFo7UeAE7WvTraCq97Yq0p2ZaM00TOaxryGgH/gJJM7vunx7DvhadJANXT7kBB39kn3TnJTI aspREQtjHX7c0Z4HArmLBXK1UoYMXxNZM= X-Google-Smtp-Source: AGHT+IHV+henyLtDwHWPc0yoyIVT9+HJMOsZgXtGBF8ohFoupTfYBeCzGUh+SOyigJthRZId9RzWOg== X-Received: by 2002:a05:6214:21e2:b0:880:4fff:7c5 with SMTP id 6a1803df08f44-88292686b89mr272081096d6.41.1763518220134; Tue, 18 Nov 2025 18:10:20 -0800 (PST) Received: from smtpclient.apple ([209.127.78.222]) by smtp.gmail.com with ESMTPSA id 6a1803df08f44-882863135cfsm124167306d6.22.2025.11.18.18.10.17 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 18 Nov 2025 18:10:19 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\)) Subject: Re: Checkpointer write combining From: Chao Li In-Reply-To: <4ECED07F-75F2-46D4-8F71-0B0DFA350777@gmail.com> Date: Wed, 19 Nov 2025 10:09:42 +0800 Cc: Nazir Bilal Yavuz , PostgreSQL Hackers , Andres Freund Content-Transfer-Encoding: quoted-printable Message-Id: References: <2FA0BAC7-5413-4ABD-94CA-4398FE77750D@gmail.com> <3FC2442D-1012-4079-A009-A0B8C45E092D@gmail.com> <6B520FA8-B805-4C0D-B8B9-202B3AF168A9@gmail.com> <0198DBB9-4A76-49E4-87F8-43D46DD0FD76@gmail.com> <4ECED07F-75F2-46D4-8F71-0B0DFA350777@gmail.com> To: Melanie Plageman X-Mailer: Apple Mail (2.3826.700.81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Nov 19, 2025, at 10:00, Chao Li wrote: >=20 >=20 >=20 >> On Nov 19, 2025, at 02:49, Melanie Plageman = wrote: >>=20 >> I no longer remember why I made that patch WIP, so I've removed that >> designation. >=20 > I just reviewed 0007. It removes the second parameter "bool = skip_recently_used=E2=80=9D from SyncOneBuffer. The function is static = and is only called in one place with skip_recently_used=3Dtrue, thus = removing the parameter seems reasonable, and without considering pinned = buffer, the function is simplified a little bit. >=20 > I only got a tiny comment: > ``` > + * We can make these check without taking the buffer content lock so > ```=20 >=20 > As you changed =E2=80=9Cthis=E2=80=9D to =E2=80=9Cthese=E2=80=9D, = =E2=80=9Ccheck=E2=80=9D should be changed to =E2=80=9Cchecks=E2=80=9D = accordingly. >=20 I just got an compile error: ``` bufmgr.c:3580:33: error: no member named 'dbId' in 'struct CkptSortItem' 3580 | batch.rlocator.dbOid =3D = item.dbId; | ~~~~ ^ bufmgr.c:3598:13: error: no member named 'dbId' in 'struct CkptSortItem' 3598 | if (item.dbId !=3D batch.rlocator.dbOid) | ~~~~ ^ 2 errors generated. make[4]: *** [bufmgr.o] Error 1 ``` I tried =E2=80=9Cmake clean=E2=80=9D and =E2=80=9Cmake=E2=80=9D again, = which didn=E2=80=99t work. I think the error is introduced by 0006. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/