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

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans
Date: 2022-09-20 22:12:00
Message-ID: CAH2-Wz=Yp6DCbhYgW5AeG0016d6thW_nq94xecjUYPNot77BpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 12, 2022 at 2:01 PM Peter Geoghegan <pg(at)bowt(dot)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

Attachment Content-Type Size
v2-0001-Shrink-freeze-WAL-records-via-deduplication.patch application/x-patch 19.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-09-20 22:56:08 Re: Auto explain after query timeout
Previous Message James Coleman 2022-09-20 21:08:45 Re: Auto explain after query timeout