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.94.2) (envelope-from ) id 1uw9ds-006dRa-OA for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Sep 2025 01:29:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uw9dr-00Fuz5-Uo for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Sep 2025 01:29:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uw9dr-00Fuyx-Ib for pgsql-hackers@lists.postgresql.org; Wed, 10 Sep 2025 01:29:00 +0000 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uw9dp-001ZUW-1o for pgsql-hackers@lists.postgresql.org; Wed, 10 Sep 2025 01:28:58 +0000 Received: by mail-pf1-x436.google.com with SMTP id d2e1a72fcca58-77238cb3cbbso6597492b3a.0 for ; Tue, 09 Sep 2025 18:28:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1757467736; x=1758072536; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=Zy2n5u5Z4UScQHystST23B+AmkrejSW6cvstBc4aQpQ=; b=mv1xoIuamf8ket8ZijWIoE4EfGfhnX0SlsJeDpGV3ZQua+2qzoynju7pwlxZxTdSSF WR7pS6JB7QXg+56Rv561gmcV+lxGeHOYRodN8pnttO8GatChQaLjB9CtR12EWteg+wlb nqvcOulopywVr1y0HcXdeLqtmAkiLRuAyj8LEBDeX/8ZjHC5INBqhA+nbxb8PuED6fes UWLolJGV7wKG72X4R+rG6zYXINfP3vN3mAVQ1H6SjMOeYcXDAg8Qwh3glNbu7WJGwBsd 744oHUm2aaVJ9l1dhOjEBBBQ0PlFGtIGicc+FzvRv01wKXU08d6vE1KbI9IlgY3Oj7it 3Gcw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757467736; x=1758072536; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Zy2n5u5Z4UScQHystST23B+AmkrejSW6cvstBc4aQpQ=; b=aeU0mtKMpKCSMpLrbluGYh49l7qpIfNRFmiMlC6ZhytAA3gYThxRaLwZQSNMAvwc6D JX6MIIWasaFhlGMpuZNK3s4cH4/lgB1tHBcCUBE6cGOFzJWPE3pSsmUfgEYzOSDRbV1H SGlDVuaS+XogwDSB3mQGn18hOc/xqKcdnIE7RWbokNIAVafRYH2VgEHw4Z+UhunKcjgr aye7KWIz0bdzY4z1pQ2fg4QEXNxiXchqoqxyNpPO9z9vQaqIYsIIVveovtuj5kD3kRQ7 6PvsDAYb60LDEVTtTV+O2OeVvGNExWle2mt7pipS85kD/I9U3dBIHmb4ww5Ze/aJJiKq EtFA== X-Gm-Message-State: AOJu0Yw5/zc4wsh7LAK4LMPQy8AUEF5DJAnKSGJciqmSLWxNBufaRTdE 38zOf4CFaVhIlFL1woeeAF7xs9LEjzpm6CSW/KtSxdQp+sutBrcFKg9NtMZHwJCwPQ== X-Gm-Gg: ASbGncuKl8zMk878o2xfQTWkHJWSrW0w8sXmxjmFfiUSk09zyn0FjZV3gS0GrA+Qush zuzCUp+D6gzzdKpl4fQDJDzLLw6g2WmGMx7HsAaQITPn/f6wIXC9Ei1jqs41V3pwANEnWWDt8on OKuYzPLilF7BrsNP/dHIOo/2+v5IfbeqIpEMsP7ccTiT74zCUjWrFllj+i+sq/h3JwYwTNaNJyq wHUr2gOff5UYly/dKv2VFT/I8COO7usXGWiMqh/c8+royZ3gfivzvtxKFt8S8471gI90MtBJysa hDonJBkVYftHQ2PiON2KDVCne4vl7DCM9OQE5LfrfX4IrumHaK+063hq7+jsK7/+JpoIpuBrYEA rYA//OWC3dokaGvpHS+mVZTinHu9d3n9IDfNa0qbMlm3iAIOAyHXXoKjTY5kCAMZHEajfC1exN1 Bj/go= X-Google-Smtp-Source: AGHT+IGOZgbgGCeApqtSsJ3mXQs/S74E2CM+icnzfZSQxGf2QjyKhVfYR9bagid4z2pCUjo10kC5vQ== X-Received: by 2002:a05:6a20:939d:b0:251:c33d:2783 with SMTP id adf61e73a8af0-2533fab6448mr17897475637.23.1757467736361; Tue, 09 Sep 2025 18:28:56 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b548a50b615sm938009a12.12.2025.09.09.18.28.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 09 Sep 2025 18:28:55 -0700 (PDT) Message-ID: Subject: Re: Checkpointer write combining From: Jeff Davis To: Melanie Plageman , Nazir Bilal Yavuz Cc: PostgreSQL Hackers , Andres Freund Date: Tue, 09 Sep 2025 18:28:55 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2025-09-09 at 13:55 -0400, Melanie Plageman wrote: > On Tue, Sep 9, 2025 at 11:16=E2=80=AFAM Melanie Plageman > wrote: > >=20 > > One more fix and a bit more cleanup in attached v4. >=20 > Okay one more version: I updated the thread on eager flushing the > bulkwrite ring [1], and some updates were needed here. v5-0005 comments: * Please update the comment above the code change. * The last paragraph in the commit message has a typo: "potentially update the local copy of min recovery point, when xlog inserts are *not* allowed", right? * Shouldn't the code be consistent between XLogNeedsFlush() and XLogFlush()? The latter only checks for !XLogInsertAllowed(), whereas the former also checks for RecoveryInProgress(). I'm still not sure I understand the problem situation this is fixing, but that's being discussed in another thread. Regards, Jeff Davis