Vacuum reaps dead items sooner for index-less tables

Edit
ID 4665
Title Vacuum reaps dead items sooner for index-less tables
Topic Performance
Created 2023-11-17 23:06:19
Last modified 2024-01-26 17:05:15 (10 months, 2 weeks ago)
Latest email 2024-01-26 18:05:48 (10 months, 2 weeks ago)
Status
2024-01: Committed
Target version
Authors Melanie Plageman (melanieplageman)
Reviewers Become reviewer
Committer Robert Haas (rhaas)
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/4665
git checkout commitfest/cf/4665
Emails
Emit fewer vacuum records by reaping removable tuples during pruning
First at 2023-11-13 22:28:50 by Melanie Plageman <melanieplageman at gmail.com>
Latest at 2024-01-26 18:05:48 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v12-0001-Combine-FSM-updates-for-prune-and-no-prune-cases.patch) at 2024-01-25 02:13:09 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v12-0001-Combine-FSM-updates-for-prune-and-no-prune-cases.patch) at 2024-01-25 02:13:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Combine-FSM-updates-for-prune-and-no-prune-cases.patch) at 2024-01-19 02:23:44 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v10-0004-Combine-FSM-updates-for-prune-and-no-prune-cases.patch) at 2024-01-18 14:53:12 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Move-VM-update-code-to-lazy_scan_prune.patch) at 2024-01-17 20:11:55 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Move-VM-update-code-to-lazy_scan_prune.patch) at 2024-01-16 23:07:24 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Be-more-consistent-about-whether-to-update-the-FS.patch) at 2024-01-16 15:24:27 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Be-more-consistent-about-whether-to-update-the-FS.patch) at 2024-01-15 17:29:57 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Be-more-consistent-about-whether-to-update-the-FS.patch.nocfbot) at 2024-01-12 19:32:13 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Move-VM-update-code-to-lazy_scan_prune.patch) at 2024-01-11 19:30:07 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Move-VM-update-code-to-lazy_scan_prune.patch) at 2024-01-09 22:42:38 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Set-would-be-dead-items-LP_UNUSED-while-pruning.patch) at 2024-01-09 20:13:30 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0004-Conslidate-FSM-update-code-in-lazy_scan_heap.patch) at 2024-01-06 15:34:59 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0004-Inline-LVPagePruneState-members-in-lazy_scan_prun.patch) at 2024-01-05 20:34:22 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Set-would-be-dead-items-LP_UNUSED-while-pruning.patch) at 2023-11-17 23:12:08 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Set-would-be-dead-items-LP_UNUSED-while-pruning.patch) at 2023-11-13 22:28:50 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
History
When Who What
2024-01-26 17:05:15 Melanie Plageman (melanieplageman) Closed in commitfest 2024-01 with status: Committed
2024-01-26 17:05:15 Melanie Plageman (melanieplageman) Changed committer to rhaas
2023-11-17 23:06:28 Melanie Plageman (melanieplageman) Changed authors to Melanie Plageman (melanieplageman)
2023-11-17 23:06:19 Melanie Plageman (melanieplageman) Attached mail thread CAAKRu_bgvb_k0gKOXWzNKWHt560R0smrGe3E8zewKPs8fiMKkw@mail.gmail.com
2023-11-17 23:06:19 Melanie Plageman (melanieplageman) Created patch record
Edit