Re: do only critical work during single-user vacuum? - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: do only critical work during single-user vacuum?
Date
Msg-id C56B730E-3E2F-4FF3-B762-72AF77848D65@amazon.com
Whole thread Raw
In response to Re: do only critical work during single-user vacuum?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On 12/9/21, 12:33 PM, "Bossart, Nathan" <bossartn@amazon.com> wrote:
> On 12/9/21, 11:34 AM, "John Naylor" <john.naylor@enterprisedb.com> wrote:
>> Now that we have a concept of a fail-safe vacuum, maybe it would be
>> beneficial to skip a vacuum in single-user mode if the fail-safe
>> criteria were not met at the beginning of vacuuming a relation. This
>> is not without risk, of course, but it should be much faster than
>> today and once up and running the admin would have a chance to get a
>> handle on things. Thoughts?
>
> Would the --min-xid-age and --no-index-cleanup vacuumdb options help
> with this?

Sorry, I'm not sure what I was thinking.  Of coure you cannot use
vacuumdb in single-user mode.  But I think something like
--min-xid-age in VACUUM is what you are looking for.

Nathan


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Added schema level support for publication.
Next
From: "Bossart, Nathan"
Date:
Subject: Re: do only critical work during single-user vacuum?