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 1w2QMw-000HDz-2a for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 09:05:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2QMs-00HMv4-1c for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 09:05:38 +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 1w2QMs-00HMuw-0b for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 09:05:38 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2QMk-00000000Zle-2hst for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 09:05:37 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-505a1789a27so28613661cf.3 for ; Tue, 17 Mar 2026 02:05:29 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773738328; cv=none; d=google.com; s=arc-20240605; b=Rj7eFyuCFcylv6RKz8ikgZPtfBKrX5Ore+LXUbC/kvMSQ3wUUGFNS831G+RLI/4Qfh x4Gxp6+TtEIb+LwmD5oK1cu3aG3nyMuHKZATDYo5iePCptsHWyrgHlKXodhnJfrG+a2V 7izhtoV9gc+REFms/3kiWFUlJEt/bywjPpheJJ0VkBPXq6SASTb6oZeFrlRoVW/Yi3ik Nj0e5uBv/Uxx+2J9qSTIkAno5qtT8r7fWvoDrhGGjLWdJA/KN2L4UGiRWmUz3WzCV98E sOoj1JWNSdaPscBOE5ThFCdg/bb35hoXMktjNhCoPJKI0NIgcJw0Q6dyIXpt0hcqhIAh cZiA== 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=8UWVVcUh5MJtag+UbOvI5XIA2wKz1UhDdsTRNDHPglU=; fh=mgwwu2Ec1+PPSpIEHefG/yi0qhIhZTlcEBRWsw5DzN0=; b=GJGAGYYBCwXAxcWE+ZfNeVxj3JASHjVBmLsiaiMPpXp6wVSHWgp8X5EPwbIASQ17Y/ EyFNPb6Sd+DvYBhui1YFgfhPwsb4sZakHQDfm1cDhlDz6+b2Ow8WWjvp6hqy0OD/bDDa wyAm4YyF6Wy1QFqLJSGuEtqzjBnZvMi6tCkHcsReTaoA/cI7aA1KoKzVbmmZM+fQBu2V SqDB7a77uHukecMKE+wWbj+0hv8L7RRSBc05fm3+t2E1YVBgsV6xfsZgOMLHZt5J1vgL NKT1UYOAmrbBQkN0L2Z6NuHcf0Jed3gLgGbyX8yIb8/8djKjZ0vwfq611JL/IqaknBQk 6pCQ==; 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=20230601; t=1773738328; x=1774343128; 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=8UWVVcUh5MJtag+UbOvI5XIA2wKz1UhDdsTRNDHPglU=; b=doH/XcUtvBwY9XpWUY1JRgpJJhLC31+dqwsS0rPNVv2FTNBwHZWq/lUgu5NR71vgDC NArnHMdlc47wFxim6XQu7sImuPH1D92slk6bvEEhxq2xgAII6MT2M5AcY6JA1PliIOQ4 nWytJe8iSukCvt4V+tKk0yb3gpxwwtTItlsWhykQcNQj/4XT7ekWSanJk8m3BWNNWLGs j1kYBaw8lPHIw4TS8qhnQtMB/6f6OmKVF11XrU6yRMbr1K0wlKMSJh6Ymj52Nek7LCCN luBn1COarr102uP0sYqlm4rTCCja9JR0Hc+WKjTMm0gZDRgMU55iFSYRB/Vv+QkPa+x7 GYpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773738328; x=1774343128; 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=8UWVVcUh5MJtag+UbOvI5XIA2wKz1UhDdsTRNDHPglU=; b=o5C3XLTULGixTTUjv0zGOXKS5hoppCv44f811tGvVc09hE8tX5ZH37GuZwbcZ3m2BR WwE1lb79zNq/MdKoryIoABA60U4y4aGkTkNw+Q4hMgjDiAwdsbEGWxDWlQvZTDe0bDqQ f8UWZ++lyfjm3MAx3OxmTWRKq7MQoXk14NexD2AXLt5VTsTXXCQTXtgio6h078N96q1K w0C93v2XVqLfS0HqZd32JIqbvEmgHfseFC5MPHjw3jyWO6mn5XxD6DTiZYpVnhGbX1pf jpAnt1ML1+UG4WUs/GKu8uJbV5koGe4+Yd9EkwjCMIKsi4NdW+sghbNubDXJdpLrZuy4 lu/Q== X-Forwarded-Encrypted: i=1; AJvYcCVsNXgaiQC3WWIgIVtlKuAAyh0Yw2nZ0RenMZztFEDdsvAV+4ZV3yyedLUkfwE63ESynZR5u1ZF2DrJYe7L@lists.postgresql.org X-Gm-Message-State: AOJu0YyjiW/mhLescZ+38i4VYtZXRiR6urBIICRWmTCa9mcAeHyUM5AQ bVC3bRvC67jfOIIdgTssbN/muDP2c4UrF+kZxNl9vFBRDTpvhTPDYF3BSKyG6o1k8QJe/C+G3Jm BoeBA3BrewBE5EGXb1l4PhMrJloQOnbI= X-Gm-Gg: ATEYQzzEKCYv0xWSQjM2B1N48vu25i1pG3m3jG2eNWWqwz/jEqUSivB4npE3C96Gs6R J7htzHvmT46UDofFeC8MRyLwyFUcxadQmRavovhC1UyTqiHPZ/vQlYi1uVAHXVGiNBNa87y84f1 gN8zJsuitTIOhs81vt+xZz8cgC3NTrTSk4SqitNlDyUZwcvNqcR+ARCAUCFRHBXwYDzJvrdMG+/ zEKxTgAL/XzKr8L2KApmiAbhEZWD81US7Yu2s7UYp0A67CHhTzp58PBtMo9U8z3rHJZ9VUXrHmj C8rF4hrUpklXl+cOD5QdC3jVhEIP0nspZP9Nty20EDnD/aUNm4gyAvQYnDBPKqxFHdAfPbskkE6 X6jTzJRVHLeBKhdRb X-Received: by 2002:ac8:7f46:0:b0:509:1470:d3b2 with SMTP id d75a77b69052e-50957e43390mr196887371cf.60.1773738327582; Tue, 17 Mar 2026 02:05:27 -0700 (PDT) MIME-Version: 1.0 References: <6BC5DBAB-6084-4BB8-8450-52E9648AB021@gmail.com> <7F5BCD7A-764D-4D8D-8E27-6F2CAAEA1CEE@gmail.com> <4379FDA3-9446-4E2C-9C15-32EFE8D4F31B@yandex-team.ru> <7ib3sa55sapwjlaz4sijbiq7iezna27kjvvvar4dpgkmadml6t@gfpkkwmdnepx> <81DAFACF-7D55-4A84-ACB0-0425D1669DB4@gmail.com> In-Reply-To: From: Kirill Reshke Date: Tue, 17 Mar 2026 14:05:16 +0500 X-Gm-Features: AaiRm52PAOFQdL7bOuGFN4MpI6UBrcGCMpl_WfysbnU4bqLUHMaqWUHLBOOlXvU Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Melanie Plageman Cc: Chao Li , Andres Freund , 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 Mon, 16 Mar 2026 at 19:53, Melanie Plageman wrote: > > On Sun, Mar 15, 2026 at 3:10=E2=80=AFPM Melanie Plageman > wrote: > > > > I've pushed a few more of the trivial commits in the set. Attached v38 > > has the remaining patches. > > Looks like cfbot wasn't able to rebase v38 on its own for some reason. > v39 attached. > > - Melanie Hi! I did take a quick look on v38-v39. 0001 & 0003 looks ok. > From 788860ded375fcf744201347b9dcbf496070bfb5 Mon Sep 17 00:00:00 2001 > From: Melanie Plageman > Date: Wed, 25 Feb 2026 16:48:19 -0500 > Subject: [PATCH v39 02/12] Add pruning fast path for all-visible and all-frozen pages For the record, does this work with DISABLE_PAGE_SKIPPING? I think we don't want the server to "fast-path" in case this option is set by the user... --=20 Best regards, Kirill Reshke