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 1w7i0I-005cGj-1H for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 22:56:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7i0G-00Dep3-2q for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 22:56:09 +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 1w7i0G-00Deon-1w for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 22:56:09 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7i0E-00000002Frx-1wkS for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 22:56:08 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-66c05fb27e4so3921296a12.2 for ; Tue, 31 Mar 2026 15:56:06 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774997766; cv=none; d=google.com; s=arc-20240605; b=hvasYNWfJjkYxI32FL3p4uBvTe28X0ziN4JDNSWRdOiTDn6eMHITGvHZenhrh3+BmE cKMomAqpxSkyoN4pM+fvjXlq+Y41unghLjJMahN7aMuHYmqG0ag+mLaZr+qpQVff8HLM s9dUNg2xZxcbQOBgy2ZpYNzeOdtIyjEdKghTPA6gH858WuM0Q+NbK54ab0SIjuL1BXEr SwQJdBY1qa48L1lI9n/U8hIycTEoI6CImj/U6o6iVqLFXTMLZk9pXQvFFnrXWgehU8Dr dENwqUws7oMQyl/xaMY19V50mILYiMnv5+0IgTpiYh3DLnS6mnlA3xGE4j3IJA4rpXlU QRCA== 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=8WHL2q1SR8vgplb4qI+Hw7YNf2np/S5CdbmBsnCfFQE=; fh=0gYdbbphLJPM/HCJE10KCZa+NJ5LunO7M0qyjT8UBac=; b=YVFad3yQWwmwnzGRa3Ctzzw4qS9zlcVSmCK8UknbDiKFwKoQFz4dvyii6R4yxKxQk7 kFnzNk3rJRSY4Pdezwfp2d04nLMdeNEssZGHH+7/3Q4D2s+GvmiVAT72D4XCBLwUKtig Jzk3Youpz7vj/foeCjWoJ3ufqMKIp9ktQE0W2OJ6Vijw0egCC/bqkd6cesVBiiwME1I6 ozU7oh9akyRJ2j3lqiN1POeq90sq00qVlKOogM7lXITRhhkkOWzr/Pw1JvcaNO1r6YmN 8j7Qyjr5lbcs9VZN8ev4OG29fiQE7HKMbDCESgZ+aiwl0gO0yREApmwNgRDP5YKQUTmo tMfA==; 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=1774997766; x=1775602566; 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=8WHL2q1SR8vgplb4qI+Hw7YNf2np/S5CdbmBsnCfFQE=; b=Nx0HfZr5x90wg38JLl3r2745jA6ybEbVVqxE0/VPRnwLQQuo3fi1h/AtRT+mvRWs1j fORKzmcdiojKRaHcBxfzXS7pIovMGYdApd8XCj53WeFpURo0eKAsA27r5ciu085DLVjC VB9KOyedYBlMkgSDAJBzmY+zCf1vPvtcHV6/P7Y6IQhtN8ERBZukywXkf1t/aS1RF3V2 +PqVjccitm31AqAzQ8U3X61II9X10caUTprBFGlKOGIEKV9HG4xzdqKgnp1SK56S+AE3 DHGqaWW1bcyvNLKbZvMLZUSj7QqTXoMERGmqpUgJ6j9x/hbXbV/b68tSXUjlg6ha/zT5 UYog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774997766; x=1775602566; 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=8WHL2q1SR8vgplb4qI+Hw7YNf2np/S5CdbmBsnCfFQE=; b=ZIlZV2AAp0S9azu+ktaL25d8u6yQOsxSFS9mtcJDJUiabSDcsL/+k8ex1MGfDPeF0t R+S/oqEnc9gWxGW8xLAqsBB3dcbMoQUrGh0qw165xwhqRkawSXJLIc9XV81HBWnVHQcL veFGnrqTpEzKkCTZTWLQJMECi4Y9jSozHtH2Y7g5yBjoT6xvE50qmgxwbvS/1EOKVKCZ 1VEogWKSJtp4nUrmJMqTZ4PHSihWJJaDopYecPC0h+r3oreZt8EjWGvM+8sVLo0eRH9i 80ajKOlHr3q0A87tDyVbbmyVUoU9GEzYKig7Kfd6+/4OPlnX7Xhb7EDFUB58MQtGXlvG nogA== X-Forwarded-Encrypted: i=1; AJvYcCVh3q7GrxpZ5EimVj5xiQx/ycvM0+nLzPDHOG7Gq257GJ7RTeT7O6N9uMaZfxKpQT9a1QBVZwWaSPcE9sJC@lists.postgresql.org X-Gm-Message-State: AOJu0YyphF5oCFtNDAC9+H9tGWENB1+5kDjJbU8GLWsX65kkZlYekKu/ AdIS+oNORDQZWHVjugxtRgqDNX5UQcEbJh8ezzoL7Fdo0G12bbXNs9oU54YsyH8NxKwNv5Ygwmg I0S+oo0pb+OCKgq9Ef3etbMHw2p93sJI= X-Gm-Gg: ATEYQzwUHWgy62tRPi3ajYGTNnvrmCkNeCJb47VcOxBG+VgiXI5W87Pd10zmp8MYQNT zR0Prsk7AC2kPC7bGe8caNkS+WljMTvHobJxWKn9bbBW/NyOuwm9Nt8AfTQt9FpqVB3JEy8BLaI AJnH8d+4HLiqqQAXJs2073MntjeyWXqEhhGkHaeV+UDIjckTaQQLsbAmrBay9D7siodT0LH+0lH zJTjI8b4pNIsK3JmQKc5BWqvdKwuOr56bBnIktTJM/y4cDPayc+Idoe91YTHXj4djviQpdET+J6 u/Zkl2Sj4NPaY22o6eIO9DoA8AYjmVEAsZQZKiLiFaum59J70FCsblFvkc5aLEWdefJas9DZubG vOO5/XQK9 X-Received: by 2002:a05:6402:3887:b0:66c:17d5:c1c9 with SMTP id 4fb4d7f45d1cf-66dafea5b53mr692728a12.5.1774997765836; Tue, 31 Mar 2026 15:56:05 -0700 (PDT) MIME-Version: 1.0 References: <2be31f17-5405-4de9-8d73-90ebc322f7d8@vondra.me> In-Reply-To: From: Melanie Plageman Date: Tue, 31 Mar 2026 18:55:54 -0400 X-Gm-Features: AQROBzDwGItlkz8S33zH50X09YgJv9w1nCXOOOnI2VXEiN5pCzHv-sx5nj6sVag Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: David Rowley Cc: Tomas Vondra , Andres Freund , Kirill Reshke , 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, Mar 31, 2026 at 6:14=E2=80=AFPM David Rowley = wrote: > > Since it's in already, maybe it'd be worth doing something more > widespread after the freeze is over, changing just the ones new to > v19. That makes sense. I've put it on my todo list for post-freeze. - Melanie