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

Peter Geoghegan <pg@bowt.ie>

From: Peter Geoghegan <pg@bowt.ie>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2022-09-20T22:12:00Z

Lists: pgsql-hackers

Attachments

v2-0001-Shrink-freeze-WAL-records-via-deduplication.patch (application/x-patch) patch v2-0001

On Mon, Sep 12, 2022 at 2:01 PM Peter Geoghegan <pg@bowt.ie> wrote:
> I'd like to talk about one such technique on this thread. The attached
> WIP patch reduces the size of xl_heap_freeze_page records by applying
> a simple deduplication process.

Attached is v2, which I'm just posting to keep CFTester happy. No real
changes here.

--
Peter Geoghegan

Commits

Rename and relocate freeze plan dedup routines.
- 50767705ed09 16.0 landed
Deduplicate freeze plans in freeze WAL records.
- 9e5405993c1e 16.0 landed