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 1w4veT-002hi0-2A for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 06:54:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4veR-004mTn-3C for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 06:54:08 +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.96) (envelope-from ) id 1w4veR-004mTf-2H for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 06:54:08 +0000 Received: from mail-qv1-xf2b.google.com ([2607:f8b0:4864:20::f2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w4veG-00000000kZN-0Tou for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 06:54:07 +0000 Received: by mail-qv1-xf2b.google.com with SMTP id 6a1803df08f44-899ed41208fso50757346d6.1 for ; Mon, 23 Mar 2026 23:53:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774335235; cv=none; d=google.com; s=arc-20240605; b=EdC+5ROrWdbd8f7EJJ/uYeMyHbVDZ+zJVe1xN1HrpQ5iZ/MxmQ78gltvls+dn4Epam Voo+w3CMuzGG2gqlM3CIdBg+ZEw2olCUxscl4YILJ7qaS32uMwYoX7I9t07MehTB9UOh ghguWwNhZKX9nW1MtrYkgPjhIoynA6cdhTaF+U7my4C6yk66qU1/HBV8YENIhgDcEAKs A5RoE6mku6oLqbd6PJTXfs+/NfJ+NjXt4+RfceAGJpcC9Cj9K5UzAxVKXBtjU8JwTdHP ESZaPJ8JxBKfuvcTxObPB1VGdct/GV2zkwwNQhsP7fwdVA5bddCagvKL57dc4B+EbuNR y+ZA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=jrrwBSsQ4U2LCRqjhM5SekHw8Mqb+X16H6cAhyesyc0=; fh=ONq7umU7j2vBy5iGRhSZpMqP7wiexOFta/2w5sLws9w=; b=YCGYM6kykzg/kMWNIN4lh/+vtCneDHPCNhlPxlpofQGQXg8a4kjbpIFNvjX6HKYJJG mkyhDXplzkRpj3MfiA9alLE0iNMXXiqQYCpZl7cdnkqE4BwGJVJE4rEZ/ZpyMAuQQMkS mDtpivn+Kwz5AH6+SW0PkmO/pabEneDAIjuix6VZg4MxVzZf/+msClUlxFeBENl7H3G5 HE9ZVnOIHVDuyplL4XU6vV+jLXJ/hypPQFQ9tzYV9rtOcqFbRVw74MC8EV0qig+iqiQV JIPpEfVScYNKox6C5qlTqdUTpxQSHqHsffdcArQeQ0LyBA8756nSRJCamsZ9fD76RRHe 9asA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774335235; x=1774940035; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=jrrwBSsQ4U2LCRqjhM5SekHw8Mqb+X16H6cAhyesyc0=; b=N5sVEZYLHLI8oRM4tE/Zt9pPiokcwBbbGcFGOixNIMirKoowhO43M/Wp5SWUXUe9o3 9ks/OjwGeDzDzqhioiLLQpYemHuWwcTOmy1ng7hzcnDYCZDfuTf0Wkxyr+Zna4CZd7Jt AGan5t0HT37JE4CPs6Bq4q5Ol3/YWyqe4kHbS7wYcQhCuBPomgAOtziQXXY9fV31secw wbTGIRllAspvDos8A6jqCWzJxXe/9vozlr8csqflHPtzEMxAtv0iPMJNw2074SU7dEOE aBZopm/iGZKK5Rp0syX0XUISuW6l6mNWOlFV0aMfyOxi+eMEaYtuoy14XjVinM2unSQ9 rHOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774335235; x=1774940035; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=jrrwBSsQ4U2LCRqjhM5SekHw8Mqb+X16H6cAhyesyc0=; b=oXq7O3T75J7kV8WZHelTtrP2ElrEA1YcK74abTyMMFUfD0dnoMfCgpArRRggqcJIst BzGBXVsUgpychScdK8+zVg51Ucsm0ez+VWMj5u/lYgLV+t5dGjJesW7EIoXOxFvzeQRd X4F2rdUJa5f2WCNSgVLu9/+CayzFnTW9CStrjUwdnUmrAEdZakksMZVL6UelQzfdSpON ddM/suuqIq7QIDgFk7KcOhyh9gRY870WNvDJcl9U0S0gEztHXTxcuCzEnl/lHTPDxwYv 0tNMTIis9RT/oPd2X2+TKriRfpBvIHL10dvNu4mpLA3tREn8ll9Hbx7UQAtrDmr9LgAx yuCA== X-Forwarded-Encrypted: i=1; AJvYcCWMyuWsZ2DokB6Ax+NIB6Sgja3Wi9YzdHndsdLZ2kK6J1+FPLY0D+Dcohrsg3eJX2vwmOhLxAPttZA4kUom@lists.postgresql.org X-Gm-Message-State: AOJu0Yy2TcOFgsCuHeQSZOO6xHrBza5hIpFILA0JW9j8WzvjFVPOKwLl WJ4dUXVth0GrXNVR6uSiPFN6QmlrMSZniypqriQg00S/G7hPFuLq9ur+b0RkdAzBZ0mgWKaKPLy CP66LSAhJkyWJ1lr+DA1VYvtiRp7PhMc= X-Gm-Gg: ATEYQzwqs7VgD/zAhOagXOnoP3d/2qQiktlUAc48Aby3xz+WMBKW1FU9baGUVftewjg lZScGIPDMMi7P1C3AJ1yhYFruceMNNH06Dqi4QeVf3QSr8EeIjYUsuQeP6iiuOOc7o/XFnPUha6 Luk2NZSi1VQm2vcTcckpwg2MVrSn0wlh2RtgoiCUZJBoC7JENnu0c72YLDs4rN/PtYtPQOlgdbN fxkM3NpEnpm4QEJBcJe4sZj1X2jjGJktNDKn/cxchqcRxsJHVsoL9bsoDis/jkEonmVYl6m51fT lnO3CJnfOuFwDw7CraDg/CsDNf+HJRb8f4TQkdJvoz9q1KJPYJNF1RihP3ReLlNmOevx5O4PEGF eO7qDXg== X-Received: by 2002:a05:6214:8101:b0:89a:18bc:2b18 with SMTP id 6a1803df08f44-89c85a9adfamr202315506d6.60.1774335235431; Mon, 23 Mar 2026 23:53:55 -0700 (PDT) MIME-Version: 1.0 References: <81DAFACF-7D55-4A84-ACB0-0425D1669DB4@gmail.com> In-Reply-To: From: Kirill Reshke Date: Tue, 24 Mar 2026 11:53:44 +0500 X-Gm-Features: AaiRm53qk34qlSPWoQrJ7jYljbeCehnH4b6-ia4rcMmBXi1N8HOPXO1KYaaTB1M Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Melanie Plageman Cc: Andres Freund , Chao Li , Andrey Borodin , Xuneng Zhou , Robert Haas , PostgreSQL Hackers , Heikki Linnakangas Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 24 Mar 2026 at 02:54, Melanie Plageman wrote: > > On Sun, Mar 22, 2026 at 3:58=E2=80=AFPM Melanie Plageman > wrote: > > > > I've pushed the first two patches. Attached are the remaining 10. No > > changes were made to those from the previous version. > > I'm planning on pushing 0001-0005 in the morning. > Thanks for taking care. I think it would be good to get WAL volume reduction in v19 from 0004 & 0005. lgtm --=20 Best regards, Kirill Reshke