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

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, 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-15 19:10:54
Message-ID: CAAKRu_ZbOp52rnkjf63h5mf94raEKBH7AAbz6QTx-xdH9yLfmQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 11, 2026 at 1:01 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> On Fri, Mar 6, 2026 at 6:33 PM Melanie Plageman
> <melanieplageman(at)gmail(dot)com> wrote:
> >
> > Thanks for the review! Attached is v36. I've pushed some of the early
> > patches in the set and this is what is left.
>
> I've gone ahead and pushed another of the introductory commits.
> Attached v37 has the remaining patches.

I've pushed a few more of the trivial commits in the set. Attached v38
has the remaining patches.

- Melanie

Attachment Content-Type Size
v38-0001-Fix-visibility-map-corruption-in-more-cases.patch text/x-patch 18.6 KB
v38-0002-Add-pruning-fast-path-for-all-visible-and-all-fr.patch text/x-patch 4.5 KB
v38-0003-Use-GlobalVisState-in-vacuum-to-determine-page-l.patch text/x-patch 11.4 KB
v38-0004-Keep-newest-live-XID-up-to-date-even-if-page-not.patch text/x-patch 14.8 KB
v38-0005-Eliminate-XLOG_HEAP2_VISIBLE-from-vacuum-phase-I.patch text/x-patch 24.7 KB
v38-0006-Eliminate-XLOG_HEAP2_VISIBLE-from-empty-page-vac.patch text/x-patch 2.6 KB
v38-0007-Remove-XLOG_HEAP2_VISIBLE-entirely.patch text/x-patch 25.0 KB
v38-0008-Track-which-relations-are-modified-by-a-query.patch text/x-patch 5.8 KB
v38-0009-Thread-flags-through-begin-scan-APIs.patch text/x-patch 28.1 KB
v38-0010-Pass-down-information-on-table-modification-to-s.patch text/x-patch 14.5 KB
v38-0011-Allow-on-access-pruning-to-set-pages-all-visible.patch text/x-patch 10.5 KB
v38-0012-Set-pd_prune_xid-on-insert.patch text/x-patch 10.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan Gonzalez V. 2026-03-15 19:36:44 Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode
Previous Message Daniel Verite 2026-03-15 18:52:24 Re: Supporting non-deterministic collations with tailoring rules.