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 0544901A-0FC5-46B5-801B-F30AC0B81A19@amazon.com
Whole thread Raw
In response to Re: do only critical work during single-user vacuum?  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: do only critical work during single-user vacuum?  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On 12/9/21, 5:06 PM, "Bossart, Nathan" <bossartn@amazon.com> wrote:
> On 12/9/21, 4:36 PM, "Peter Geoghegan" <pg@bowt.ie> wrote:
>> We could then apply this criteria in new code that implements this
>> "big red button" (maybe this is a new option for the postgres
>> executable, a little like --single?). Something that's reasonably
>> targeted, and dead simple to use.
>
> +1

As Andres noted, such a feature might be useful during normal
operation, too.  Perhaps the vacuumdb --min-xid-age stuff should be
moved to a new VACUUM option.

Nathan


pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: do only critical work during single-user vacuum?
Next
From: Peter Geoghegan
Date:
Subject: Re: do only critical work during single-user vacuum?