New strategies for freezing, advancing relfrozenxid early

Title

Topic

Performance

Created

2022-08-25 21:29:40

Last modified

2023-01-26 06:23:49 (1 year, 7 months ago)

Latest email

2023-01-27 18:40:10 (1 year, 7 months ago)

Status

2023-01: Withdrawn

2022-11: Moved to next CF

2022-09: Moved to next CF

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Matthias van de Meent (mmeent)Become reviewer

Committer

Links

Wiki

Emails

New strategies for freezing, advancing relfrozenxid early: First at 2022-08-25 21:21:12 by Peter Geoghegan <pg at bowt.ie>
Latest at 2023-01-27 18:40:10 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v17-0001-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch) at 2023-01-24 22:49:38 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v17-0001-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch) at 2023-01-24 22:49:38 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v16-0003-Finish-removing-aggressive-mode-VACUUM.patch) at 2023-01-16 18:10:25 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v15-0001-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch) at 2023-01-09 01:45:41 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v14-0001-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch) at 2023-01-03 20:30:02 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (0001-Tweak-page-level-freezing-comments.patch) at 2023-01-02 19:45:11 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v13-0002-Add-eager-and-lazy-VM-strategies-to-VACUUM.patch) at 2022-12-28 17:34:02 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v12-0002-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch) at 2022-12-26 20:53:52 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v11-0001-Add-page-level-freezing-to-VACUUM.patch) at 2022-12-22 19:39:10 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v10-0005-Finish-removing-aggressive-mode-VACUUM.patch) at 2022-12-18 22:20:49 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v9-0005-Finish-removing-aggressive-mode-VACUUM.patch) at 2022-12-11 02:11:21 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v8-0004-Add-eager-freezing-strategy-to-VACUUM.patch) at 2022-11-23 23:06:52 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v7-0005-Avoid-allocating-MultiXacts-during-VACUUM.patch) at 2022-11-19 01:06:57 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v6-0005-Avoid-allocating-MultiXacts-during-VACUUM.patch) at 2022-11-16 03:02:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (routine-vacuuming.html) at 2022-10-17 23:52:11 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v4-0001-Add-page-level-freezing-to-VACUUM.patch) at 2022-09-13 17:53:06 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Add-page-level-freezing-to-VACUUM.patch) at 2022-09-08 20:23:52 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Add-page-level-freezing-to-VACUUM.patch) at 2022-08-31 22:05:52 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Add-page-level-freezing-to-VACUUM.patch) at 2022-08-25 21:21:12 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2023-01-26 17:23:31	Matthias van de Meent (mmeent)	Added mmeent as reviewer
2023-01-26 06:23:49	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2023-01 with status: Withdrawn
2022-12-13 23:50:56	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-13 23:21:24	Peter Geoghegan (pgeoghegan)	Changed wikilink to https://wiki.postgresql.org/wiki/Freezing/skipping_strategies_patch:_motivating_examples
2022-12-13 23:21:05	Peter Geoghegan (pgeoghegan)	Changed wikilink to https://wiki.postgresql.org/wiki/Freezing/skipping_strategies_patch:_motivating_examples#Opportunistically_advancing_relfrozenxid_with_bursty.2C_real-world_workloads
2022-10-17 23:52:37	Peter Geoghegan (pgeoghegan)	New status: Needs review
2022-10-12 08:31:00	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:30:57	Michael Paquier (michael-kun)	New status: Waiting on Author
2022-08-25 21:29:49	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2022-08-25 21:29:40	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-WzkFok_6EAHuK39GaW4FjEFQsY=3J0AAd6FXk93u-Xq3Fg@mail.gmail.com
2022-08-25 21:29:40	Peter Geoghegan (pgeoghegan)	Created patch record