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

From: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: do only critical work during single-user vacuum?
Date: 2021-12-10 01:11:57
Message-ID: 0544901A-0FC5-46B5-801B-F30AC0B81A19@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/9/21, 5:06 PM, "Bossart, Nathan" <bossartn(at)amazon(dot)com> wrote:
> On 12/9/21, 4:36 PM, "Peter Geoghegan" <pg(at)bowt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2021-12-10 01:25:53 Re: do only critical work during single-user vacuum?
Previous Message Bossart, Nathan 2021-12-10 01:06:33 Re: do only critical work during single-user vacuum?