| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | 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-22 19:58:27 |
| Message-ID: | CAAKRu_Zj8G4T=HN3QSY7iQvkKSQk-k1fq+eJkjCBNqoSg63z+Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Mar 20, 2026 at 7:37 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> I've made several minor updates and two notable updates in attached v42:
>
> - no separate log_newpage_buffer() for empty page vacuum.
> log_heap_prune_and_freeze() now handles pages without a valid LSN on
> its own
> - the heap_page_is_all_visible() assertion should be stable even once
> it uses GlobalVisState because I've updated the GloablVisState
> functions to avoid updating the GlobalVisState boundaries in this case
I've pushed the first two patches. Attached are the remaining 10. No
changes were made to those from the previous version.
- Melanie
| Attachment | Content-Type | Size |
|---|---|---|
| v43-0001-Use-GlobalVisState-in-vacuum-to-determine-page-l.patch | text/x-patch | 18.2 KB |
| v43-0002-Keep-newest-live-XID-up-to-date-even-if-page-not.patch | text/x-patch | 15.4 KB |
| v43-0003-WAL-log-VM-setting-during-vacuum-phase-I-in-XLOG.patch | text/x-patch | 23.1 KB |
| v43-0004-WAL-log-VM-setting-for-empty-pages-in-XLOG_HEAP2.patch | text/x-patch | 5.6 KB |
| v43-0005-Remove-XLOG_HEAP2_VISIBLE-entirely.patch | text/x-patch | 27.5 KB |
| v43-0006-Track-which-relations-are-modified-by-a-query.patch | text/x-patch | 8.7 KB |
| v43-0007-Thread-flags-through-begin-scan-APIs.patch | text/x-patch | 32.9 KB |
| v43-0008-Pass-down-information-on-table-modification-to-s.patch | text/x-patch | 11.3 KB |
| v43-0009-Allow-on-access-pruning-to-set-pages-all-visible.patch | text/x-patch | 10.1 KB |
| v43-0010-Set-pd_prune_xid-on-insert.patch | text/x-patch | 8.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yamaguchi Atsuo | 2026-03-22 20:30:30 | Add tab completion for SERVER and CONNECTION keywords in psql |
| Previous Message | Álvaro Herrera | 2026-03-22 19:37:47 | Re: Adding locks statistics |