Re: do only critical work during single-user vacuum?

On 12/9/21, 12:33 PM, "Bossart, Nathan" <bossartn(at)amazon(dot)com> wrote:
> On 12/9/21, 11:34 AM, "John Naylor" <john(dot)naylor(at)enterprisedb(dot)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