Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, Andres Freund <andres(at)anarazel(dot)de>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Xuneng Zhou <xunengzhou(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Date: 2026-03-29 17:16:39
Message-ID: CAAKRu_atv6zA274m8Ysgbfn49c0NbdvHT7nXvd9kroZKnFq8Dg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 27, 2026 at 3:17 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> Done in v47.

Attached v48 does a bit more cleanup. No functional changes. I'm
planning to push this soon. I think my remaining question is whether I
should move the row marks and result relation bitmaps into the estate.
I'm leaning toward not doing that and leaving them in the PlannedStmt.
Anyway, If I want to replace the list of result relation RTIs in the
PlannedStmt, I have to leave the bitmapset version there.

- Melanie

Attachment Content-Type Size
v48-0001-Make-it-cheap-to-check-if-a-relation-is-modified.patch text/x-patch 4.4 KB
v48-0002-Remove-PlannedStmt-resultRelations-in-favor-of-r.patch text/x-patch 3.8 KB
v48-0003-Thread-flags-through-begin-scan-APIs.patch text/x-patch 37.1 KB
v48-0004-Pass-down-information-on-table-modification-to-s.patch text/x-patch 10.0 KB
v48-0005-Allow-on-access-pruning-to-set-pages-all-visible.patch text/x-patch 9.9 KB
v48-0006-Set-pd_prune_xid-on-insert.patch text/x-patch 8.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2026-03-29 17:56:25 Add max_wal_replay_size connection parameter to libpq
Previous Message Pavel Stehule 2026-03-29 16:42:46 PoC - psql - emphases line with table name in verbose output