| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
| Cc: | Alexander Lakhin <exclusion(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tomas Vondra <tomas(at)vondra(dot)me>, David Rowley <dgrowleyml(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(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-09-23 21:21:43 |
| Message-ID: | CAAKRu_byZAQSMa3r5GD84S_q1qQPaYxwDu-kEJ3rO=qjbb-6=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Sep 21, 2026 at 12:18 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> I've tightened up the commit messages in the latest version and
> changed 0002 as you suggested. I'll commit 0001-0003 after beta4 is
> tagged tomorrow. 0004 I'm going to think about just a bit longer (and
> would be master only).
I've committed all but v2-0004. That turned out to have a bug where I
updated the prune_xid to newest_live_xid even when there were dead
items (because that code runs before we set all-visible to false due
to dead items. Attached v3 fixes that and has a patch to replace
foreach with foreach_int and foreach_node which David suggested a long
time ago and I never got around to. 0001 targets master only, 0002
targets 19 and master. I'll commit 0002 very shortly since it's so
trivial.
- Melanie
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Retain-newest-live-xid-as-prune-hint-after-visibi.patch | text/x-patch | 1.9 KB |
| v3-0002-Use-typed-foreach-macros-for-planner-relation-lis.patch | text/x-patch | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2026-09-23 21:55:49 | Re: Set calcSumX2 = true in numeric_(poly_)deserialize |
| Previous Message | Masahiko Sawada | 2026-09-23 21:19:50 | Re: [PATCH] Use bounded GIN pending-list cleanup in parallel autovacuum |