Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans

Title

Topic

Performance

Created

2022-09-12 21:02:40

Last modified

2022-11-15 16:00:19 (2 years ago)

Latest email

2022-11-15 18:26:05 (2 years ago)

Status

2022-11: Committed

Target version

Authors

Peter Geoghegan (pgeoghegan)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Peter Geoghegan (pgeoghegan)

Links

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/3886
git checkout commitfest/cf/3886

Emails

Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans: First at 2022-09-12 21:01:34 by Peter Geoghegan <pg at bowt.ie>
Latest at 2022-11-15 18:26:05 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (v4-0001-Shrink-freeze-WAL-records-via-deduplication.patch) at 2022-11-11 18:38:57 from Peter Geoghegan <pg at bowt.ie>
    Attachment (v4-0001-Shrink-freeze-WAL-records-via-deduplication.patch) at 2022-11-11 18:38:57 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Shrink-freeze-WAL-records-via-deduplication.patch) at 2022-11-11 00:48:17 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Shrink-freeze-WAL-records-via-deduplication.patch) at 2022-09-20 22:12:00 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v1-0001-Shrink-freeze-WAL-records-via-deduplication.patch) at 2022-09-12 21:01:34 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)

History

When	Who	What
2022-11-15 16:00:19	Peter Geoghegan (pgeoghegan)	Closed in commitfest 2022-11 with status: Committed
2022-11-15 16:00:19	Peter Geoghegan (pgeoghegan)	Changed committer to pgeoghegan
2022-09-21 20:14:07	Nathan Bossart (bossartn)	Added bossartn as reviewer
2022-09-12 21:02:47	Peter Geoghegan (pgeoghegan)	Changed authors to Peter Geoghegan (pgeoghegan)
2022-09-12 21:02:40	Peter Geoghegan (pgeoghegan)	Attached mail thread CAH2-Wz=XytErMnb8FAyFd+OQEbiipB0Q2FmFdXrggPL4VBnRYQ@mail.gmail.com
2022-09-12 21:02:40	Peter Geoghegan (pgeoghegan)	Created patch record