Re: New strategies for freezing, advancing relfrozenxid early

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: New strategies for freezing, advancing relfrozenxid early
Date: 2023-01-16 18:10:25
Message-ID: CAH2-Wzn39Frcw4ZxkC9oP+7tpud+BiE6kTCCPrU=KqCtPZ+rSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jan 8, 2023 at 5:45 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> I didn't have time to incorporate any of the feedback from Matthias
> just yet. That will have to wait until v16.

Attached is v16, which incorporates some of Matthias' feedback.

I've rolled back the major restructuring to the "Routine Vacuuming"
docs that previously appeared in 0003, preferring to take a much more
incremental approach. I do still think that somebody needs to do some
major reworking of that, just in general. That can be done by a
separate patch. There are now only fairly mechanical doc updates in
all 3 patches.

Other changes:

* vacuum_freeze_strategy_threshold is now MB-based, and can be set up to 512TB.

* Various refinements to comments.

--
Peter Geoghegan

Attachment Content-Type Size
v16-0003-Finish-removing-aggressive-mode-VACUUM.patch application/x-patch 36.7 KB
v16-0002-Add-eager-and-lazy-VM-strategies-to-VACUUM.patch application/x-patch 85.9 KB
v16-0001-Add-eager-and-lazy-freezing-strategies-to-VACUUM.patch application/x-patch 18.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2023-01-16 18:53:13 Re: Record queryid when auto_explain.log_verbose is on
Previous Message Peter Geoghegan 2023-01-16 18:00:52 Re: New strategies for freezing, advancing relfrozenxid early