Re: Automatic autovacuum to prevent wraparound - PG13.5 - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: Automatic autovacuum to prevent wraparound - PG13.5
Date
Msg-id CAH2-Wzn4WXBLM8M5p7Sf3noub8fVoRL-ZCRrPp1=-X9Tt1cs+A@mail.gmail.com
Whole thread Raw
In response to Automatic autovacuum to prevent wraparound - PG13.5  (Mauro Farracha <farracha@gmail.com>)
List pgsql-general
On Wed, Jun 15, 2022 at 4:13 AM Mauro Farracha <farracha@gmail.com> wrote:
> The scenario:
> - Out of nowhere (during the weekend), without database activity load or batches running, with previous nightly run
ofvacuum freeze, in the middle of the day, with xids and mxids below 20M we are seeing autovacuum being triggered to
preventwraparound.
 
>
> My question is why this is occurring, which condition might be responsible for this behaviour?

There is a behavior that seems like it might be relevant: VACUUM
interprets autovacuum_multixact_freeze_max_age in a way that accounts
for both MultiXactId consumption and the consumption of "member space"
by MultiXacts. Technically there are 2 SLRUs for MultiXacts, either of
which can wraparound.

This behavior was established by commit 53bb309d2d. It is documented.
Admittedly this whole area of the documentation is in dire need of an
overhaul.  :-(

-- 
Peter Geoghegan



pgsql-general by date:

Previous
From: Ninad Shah
Date:
Subject: Re: Automatic autovacuum to prevent wraparound - PG13.5
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Tuning a query with ORDER BY and LIMIT