| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | Kirill Reshke <reshkekirill(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, 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: | 2025-11-20 17:19:58 |
| Message-ID: | CAAKRu_amF00f2T_H8N6pbbe75C22EeX1OqA=svpj8LNO1sdUuw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Nov 19, 2025 at 6:13 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> Since it is passed into one of the helpers, I think I agree. Attached
> v21 has this change.
I've committed the first three patches. Attached v22 is the remaining
patches which set the VM in heap_page_prune_and_freeze() for vacuum
and then allow on-access pruning to also set the VM.
- Melanie
| Attachment | Content-Type | Size |
|---|---|---|
| v22-0001-Split-heap_page_prune_and_freeze-into-helpers.patch | text/x-patch | 25.4 KB |
| v22-0002-Eliminate-XLOG_HEAP2_VISIBLE-from-vacuum-phase-I.patch | text/x-patch | 43.4 KB |
| v22-0003-Eliminate-XLOG_HEAP2_VISIBLE-from-empty-page-vac.patch | text/x-patch | 2.5 KB |
| v22-0004-Remove-XLOG_HEAP2_VISIBLE-entirely.patch | text/x-patch | 26.2 KB |
| v22-0005-Rename-GlobalVisTestIsRemovableXid-to-GlobalVisX.patch | text/x-patch | 8.0 KB |
| v22-0006-Use-GlobalVisState-in-vacuum-to-determine-page-l.patch | text/x-patch | 10.5 KB |
| v22-0007-Unset-all_visible-sooner-if-not-freezing.patch | text/x-patch | 2.4 KB |
| v22-0008-Allow-on-access-pruning-to-set-pages-all-visible.patch | text/x-patch | 37.7 KB |
| v22-0009-Set-pd_prune_xid-on-insert.patch | text/x-patch | 6.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ayush Vatsa | 2025-11-20 17:52:41 | Re: Clarification on when _PG_init() is invoked for extensions |
| Previous Message | Melanie Plageman | 2025-11-20 17:16:37 | Re: Odd openbsd CI failure |