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 1w7hM9-005bej-06 for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 22:14:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7hM7-00DW8i-1a for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 22:14:39 +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 1w7hM7-00DW8a-0i for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 22:14:39 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7hM6-000000022QY-00uB for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 22:14:38 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-439d8dc4ae4so6083592f8f.2 for ; Tue, 31 Mar 2026 15:14:37 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774995277; cv=none; d=google.com; s=arc-20240605; b=MYf48mztx2GgYWkHFLnTwLfXpKw9lec/k1GM+kN0CLk5e9rcvtOw4FITfq5ZwTcgkJ FsZGeU5BnvtlFAoGV12vyJ+GJqRh3/wFsm+X0Ocxqi504APnzLVhHgRS0b+kRiX40Qld ivAwqm8MPYCbSZ8oonbDCSJC8dPCh/RGsD5kpqOd5kx+OlLfxJx2WUuJUFnSyxoYFzNE GvbPLzVgWyavJ8kyoQdnFWaSWqRLI/DEABZSdqOSEIke8olpDCEuWTgqfqf/0jk6YJ9O WXKAyU5hmxm2mAUB1piLFsnkfTEn4YDfBh//VwRSa0OSyOs571iiM9uEGriwx7VeGeQY USJw== 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=5k3SizHlJdWD+B9e8YoQOs6zRBdfGFFJX+t0hw3INQg=; fh=BN5uTU6Ju8DCAtRMePp36faEa9sh2b4L/TCRUV73uTk=; b=dA5045GAYgkeyizIdZk4MGmrI9c68or8z013B24NfZRBP0pYuKGMwynABIK8TmEDJl DrJgS6PnalSbSaY8zfc1Wm2zqMZQxFB/UYv0C8ih7eJ6NiuPBneyGuTeAtAjuULzqjVt 4n95DsP3K5oG2RuG/J8YoCQRM6eesIzgLMUfpJKaGEYMhqW4VMsCrZjLtyoi3taM6aoF Nkcrhp6EjTcBFVwLDnwuGQDUzm/Ez418iL6+Y2RH2iJx/0JB8SrKqwGT2jorh32tie8y ZABwudcwM0Sw+0CQaUgJMTi4k7brEr2/d8SzLrwmmvjK53/DUXKSJ6lM41WDG2A+F2Y4 LBBA==; 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=1774995277; x=1775600077; 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=5k3SizHlJdWD+B9e8YoQOs6zRBdfGFFJX+t0hw3INQg=; b=RQSYRuTwgAP0wUTiG05UwzuEu6mQ5+dteVPSWzDILAa6/LTjX7dJK8SIS4em0BG6k7 9Z07aXC6X8srNMUPcgck4Qw01hJd4SGWkVL4AAl3HvHAqXdwvsnDzuXf0RPBpnMNTqUD yckDLidF+YmvebrFCSnyQj1Gm72BtPMxltx7eKBRgEZT1P3gh80VxfFVrqzrXZomW0T9 qSbhesl2dVg2pkfjrm8BnKiKBLEU7CXTlhCE3vhpGho0AyOaYCPDEN9/HW8PcF1pQmih CFEFk12mr3zdpTdoG41lsy9bL1J5sgMetwwT4MHNh+NmG4B+aFYpt+4bj3nvwhETXj2j 3XtQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774995277; x=1775600077; 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=5k3SizHlJdWD+B9e8YoQOs6zRBdfGFFJX+t0hw3INQg=; b=F1QnFIgj3SMRHHHCYGnO7pVChpSNLKsGRzQfPZQDbMygbPR6j1NrLOL0EFTvqbPbsM SbKfFTykARsIrzfFVFO1fhxReDVFWcpr5tsVdR+N1nxdT1muYOZL3FcOjP7PbNkXClKq SeLFCtJGPf1NvFWZ4LbmjAXlmujLX1uxmRBfpKFIsD15HvN0kcwIjndzPvNEliHhD8Bg FISefQ36SEw8rZfxN9O2K4hiWDTsTLvW9x/48XIJbvSze2xzwSmp+13Zb8tozXgfz46g Dj7zFMvLzqEzC/PsJhosG9aGPk7lbwIhsDsDnZXxCHtS24C1ReLc4BNw0sV4x/PjVylZ OFVg== X-Forwarded-Encrypted: i=1; AJvYcCV3zziTaniYoAMwm0cwiHxS0iFh3s3cHyCTftiGxDQs5v/fSCmxI48h3zuhpReEyR8eAtwS3qgHjOxLNPyV@lists.postgresql.org X-Gm-Message-State: AOJu0YzAaq+bRQT+K39bAYVDxwNSdz2fQm5HFPPnwNnAFbQcs/DZDyFL W96wETH3bFoXSqZMkVf5E5OLy1o/q7J/tu1XBCrg1TudqiVaOvI4IdyQ8j/JLXHVh4y0sEK5lBb agICq1oDZMmqyw9QURCIk2FAVJ4TbgAo= X-Gm-Gg: ATEYQzyLxZgAH5IMHRk5lrdFsk3EayVFK6+a4aVnQYA60pHIfGyfMpsYGfuqe3oLfpJ Fj1uu8FoV4SvN/Me0dxQyAPa9e2Ejbm3jKnd9RzV2GTOtuN3V/jJBY+jytHyE1UyOkcP0QYrBAy yx2jM2Q6thXTpTSIl5l617NlACn4tSrIESTx4HnhTFZEs750IE1yLvE0ijoeR0ENyZzml63hYGU o8pwRbwgR4R7Ptf64ziV7DnbqO+VZmUPU39bUomSHVGKCnVU5EknfwK0BIukEpsK68Io7MymqFJ VcqSTQtMG4+G7WQG5IngTBOmGMD8LUQCC9jI4go/675zfWEbpzsqRQq7rV2vU0N+49Dmg/2ZOw= = X-Received: by 2002:a05:6000:4285:b0:43c:ef4f:79dc with SMTP id ffacd0b85a97d-43d15042623mr2335838f8f.8.1774995276495; Tue, 31 Mar 2026 15:14:36 -0700 (PDT) MIME-Version: 1.0 References: <2be31f17-5405-4de9-8d73-90ebc322f7d8@vondra.me> In-Reply-To: From: David Rowley Date: Wed, 1 Apr 2026 11:14:23 +1300 X-Gm-Features: AQROBzBOWCBGpeaNH3MRpstw94X2Tv55cw-hiNFebaSgG02W6XGueceq7P7m6yE Message-ID: Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) To: Melanie Plageman 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 Wed, 1 Apr 2026 at 05:19, Melanie Plageman w= rote: > > Thanks for the reply! I have committed the patches in this thread and > marked the CF entry accordingly. Yeah, realised that after sending the email. > On Mon, Mar 30, 2026 at 10:17=E2=80=AFPM David Rowley wrote: > > > > I looked at v48-0001 and it looks fine to me. I've only minor quibbles > > about you using foreach() instead of foreach_int() and foreach_node() > > for populating the new Bitmapsets in standard_planner(). > > Good point. I forgot about those. Attached patch fixes that (since the > code was already committed). 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. git diff 2652835d3efa003439ecc23d5fc3cf089c5952a6.. -- *.c | grep -E "^\+\s+foreach\(" or with a bit more context: git diff 2652835d3efa003439ecc23d5fc3cf089c5952a6.. -- *.c | grep -E "(^\+\s+foreach\(|^---)" The mixed node ones don't qualify, but it shouldn't be too hard to filter those out manually. David