Eagerly scan all-visible pages to amortize aggressive vacuum

Edit
ID 5366
Title Eagerly scan all-visible pages to amortize aggressive vacuum
Topic Performance
Created 2024-11-02 16:31:48
Last modified 2025-02-11 18:56:47 (17 hours, 8 minutes ago)
Latest email 2025-02-11 18:57:25 (17 hours, 7 minutes ago)
Status
2025-03: Committed
2025-01: Moved to next CF
Target version
Authors Melanie Plageman (melanieplageman)
Reviewers Become reviewer
Committer Melanie Plageman (melanieplageman)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5366
git checkout commitfest/cf/5366
Emails
Eagerly scan all-visible pages to amortize aggressive vacuum
First at 2024-11-01 23:35:22 by Melanie Plageman <melanieplageman at gmail.com>
Latest at 2025-02-11 18:57:25 by Melanie Plageman <melanieplageman at gmail.com>
Latest attachment (v17-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-02-11 15:35:07 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v17-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-02-11 15:35:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-02-05 17:23:29 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-02-04 17:44:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (gaussian_tpcb_22hr.png) at 2025-02-03 17:19:32 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v14-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-01-29 19:12:52 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-01-29 14:08:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-01-27 21:21:53 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-01-27 17:44:51 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Eagerly-scan-all-visible-pages-to-amortize-aggre.patch) at 2025-01-24 20:02:21 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Eagerly-scan-all-visible-pages-to-amortize-aggres.patch) at 2025-01-22 22:48:46 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Eagerly-scan-all-visible-pages-to-amortize-aggres.patch) at 2025-01-15 20:55:52 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (vacuum_description.diff) at 2025-01-15 17:08:41 from Alena Rybakina <a.rybakina at postgrespro.ru> (Patch: Yes)
    Attachment (v7-0002-Eagerly-scan-all-visible-pages-to-amortize-aggres.patch) at 2025-01-14 19:51:05 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Eagerly-scan-all-visible-pages-to-amortize-aggres.patch) at 2025-01-13 21:46:47 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v5-0003-Eagerly-scan-all-visible-pages-to-amortize-aggres.patch) at 2025-01-07 20:46:26 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-more-general-summary-to-vacuumlazy.c.patch) at 2024-12-23 17:50:13 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (appendonly.png) at 2024-12-17 22:50:31 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v2-0001-Rename-LVRelState-frozen_pages.patch) at 2024-12-13 22:53:00 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0004-Replace-uses-of-blkno-local-variable-in-lazy_scan.patch) at 2024-11-01 23:35:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
History
When Who What
2025-02-11 18:56:47 Melanie Plageman (melanieplageman) Closed in commitfest 2025-03 with status: Committed
2025-02-11 18:56:37 Melanie Plageman (melanieplageman) Added melanieplageman as committer
2025-02-03 14:35:24 Melanie Plageman (melanieplageman) Closed in commitfest 2025-01 with status: Moved to next CF
2024-11-02 16:32:00 Melanie Plageman (melanieplageman) Changed authors to Melanie Plageman (melanieplageman)
2024-11-02 16:31:49 Melanie Plageman (melanieplageman) Attached mail thread CAAKRu_ZF_KCzZuOrPrOqjGVe8iRVWEAJSpzMgRQs=5-v84cXUg@mail.gmail.com
2024-11-02 16:31:48 Melanie Plageman (melanieplageman) Created patch record
Edit