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 1v8VwW-001xrq-Je for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Oct 2025 03:43:20 +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 1v8VwU-00A1wb-66 for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Oct 2025 03:43:19 +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 1v8VwT-00A1wS-GG for pgsql-hackers@lists.postgresql.org; Tue, 14 Oct 2025 03:43:18 +0000 Received: from fout-a7-smtp.messagingengine.com ([103.168.172.150]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v8VwS-001dtK-2I for pgsql-hackers@lists.postgresql.org; Tue, 14 Oct 2025 03:43:17 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id 9B64BEC0093; Mon, 13 Oct 2025 23:43:15 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Mon, 13 Oct 2025 23:43:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1760413395; x=1760499795; bh=701wxtY9Li /JrgFvnkdBb6MUMYDCxYIaiiA0RujcY/w=; b=ZnzyRaj6x40+QJuDiX6fW4Sdsp zkH9QmqAWli3CMPGw+hs+sSWUpeN0tDNdqZzySFvvIN1ny8Pg/qsbfgenP/8hwm1 nhtkqLCe63YPKo1O5GksWLbLaLRhUxzZEj8RWOl633caio2Y5YOMXP9HyZv4UfDR 2LOIxIsn5IVD+v4sVTFxZ2oaw4EOi4yNQ8yj+0atoOp5M+Uhjt/WYIOfnRStmV3+ Y1CtZCcNgrZdR7RLoR8ofIcx5rYemD4YMbM0qqDu/VGQj8oYQ4NvI/z/fSu+wwxt QiUEv6hAcflRzauI5xEYngUFHGa9P+M3rH1Azp8+E1XV6vfgzCupEfoCEGmg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1760413395; x=1760499795; bh=701wxtY9Li/JrgFvnkdBb6MUMYDCxYIaiiA 0RujcY/w=; b=alBm3htvwzslQ0uls/MhIVEIy5ry4giJww8sSRmgTtywWuRkBt1 9pYDdIjiDhXiVX7ugFIOyaXalTXQuxN6KxngNi3jWuY3VhmfYJBCxlpu2rV+7oGS UUYDICvkWDVnnZENi3JIPqfEYB3cVK39Nk4X78LNVEYR97WcHofLSMxCGxq3TPPx WN850YcXAAbFDnOfHJLfPvPEYe424hcGtX5beYfFeGc39OtYpnMmkTLXe1YGtntC E9gB0GCTJSrQiLo/tj6Uhza4xASFeO0DZL7V+lQhJXut60CLL/KZlS36ZipKhcJQ kJlK8xCd3HhkmlR9boMlbMYi0ELSgB67smg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduudelgeekucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrh hlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeggeeg fffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidp nhgspghrtghpthhtohepjedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprhgvsh hhkhgvkhhirhhilhhlsehgmhgrihhlrdgtohhmpdhrtghpthhtohepmhgvlhgrnhhivghp lhgrghgvmhgrnhesghhmrghilhdrtghomhdprhgtphhtthhopehrohgsvghrthhmhhgrrg hssehgmhgrihhlrdgtohhmpdhrtghpthhtoheprghnughrvghssegrnhgrrhgriigvlhdr uggvpdhrtghpthhtohepgiegmhhmmheshigrnhguvgigqdhtvggrmhdrrhhupdhrtghpth htohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhlrdho rhhgpdhrtghpthhtohephhhlihhnnhgrkhgrsehikhhirdhfih X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 13 Oct 2025 23:43:12 -0400 (EDT) Date: Tue, 14 Oct 2025 12:42:59 +0900 From: Michael Paquier To: Kirill Reshke Cc: Melanie Plageman , Robert Haas , Andres Freund , Andrey Borodin , PostgreSQL Hackers , Heikki Linnakangas Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="VsHhlUtZetBEdIZG" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --VsHhlUtZetBEdIZG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Oct 14, 2025 at 08:31:04AM +0500, Kirill Reshke wrote: > Hi! Should we also bump XLOG_PAGE_MAGIC after d96f87332 & add323da40a > or do we wait for full set to be committed? I may be missing something, of course, but d96f87332 has not changed the WAL format, VISIBILITYMAP_ALL_VISIBLE and VISIBILITYMAP_ALL_FROZEN existing before that. The change in xl_heap_prune as done in add323da40a6 should have bumped the format number. -- Michael --VsHhlUtZetBEdIZG Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmjtxsMACgkQnvQgOdby QH18Ng//WTMeAKZ+K3S12JUs+n1xBzeQibCnr8Et9pUY1BiLjv6npDASPSrBXQci ovzF2TGzEbVIUiTKtpPDnXi9GDB6AUgMfhnEVIV9i7uZWFY5Q80pu1wLfrz0bvqt AQ+H6noQfWeBT3PuAQ70vG2r2wY65dLi/EAd3VYgBiZ4ywQ5nrFzC2dJRNCMgUXs j7Jsy0sNndVYI4ebZy/mpcRwFaQ74FTpGl0+V/ZFO+dF10jZR0/MjMZoLF4MdkMb jwOqLXqKzFXOEUi4VC/uBMlkj9zV/URVOlTPmj9ljB1jOhJWp5vpXk1f3mhCpJ3n lGxfohfKNKIgDCwSbLpS9xFoPu1GCgIz3OOEKS4bsAF9deThidW7qx6KLSbn4sdm GCPxK+y5Ask4/de6zi7lJq7icZkW91wOCib4SqS/YN0Um6CO8Zt7Phn1s0vXXGHG mzpdpyyyxbpPnbvSbQrd658idjWB+rolSB83u+kv0wjsAHRh47ncBDkUqTlFCjM5 bM7oSOdhLfrEbUMOjZvSmmGu+yL5Wk2jaguq+aGJQbiRbwD+VFlPpqRJwsqlNJ7J j2w794BFTlFfca9toKzHoEbwtvlEBxqds6kFl/wvbsnHM4zKbtiaiKsdJLg7uuBy 7q/UIQp/s9VExkHE/yJJd5HBaHqutoYvrHy/Qpsf1W8TdQf8MEg= =gTog -----END PGP SIGNATURE----- --VsHhlUtZetBEdIZG--