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

Поиск
Список
Период
Сортировка
От Bossart, Nathan
Тема Re: do only critical work during single-user vacuum?
Дата
Msg-id 2E490EFA-541B-44BA-84CB-8229E304188B@amazon.com
обсуждение исходный текст
Ответ на Re: do only critical work during single-user vacuum?  (John Naylor <john.naylor@enterprisedb.com>)
Ответы Re: do only critical work during single-user vacuum?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On 1/19/22, 11:15 AM, "John Naylor" <john.naylor@enterprisedb.com> wrote:
> This seems to be the motivating reason for wanting new configurability
> on the server side. In any case, new knobs are out of scope for this
> thread. If the use case is compelling enough, may I suggest starting a
> new thread?

Sure.  Perhaps the new top-level command will use these new options
someday.

> Regarding the thread subject, I've been playing with the grammar, and
> found it's quite easy to have
>
> VACUUM FOR WRAPAROUND
> or
> VACUUM FOR EMERGENCY
>
> since FOR is a reserved word (and following that can be an IDENT plus
> a strcmp check) and cannot conflict with table names. This sounds a
> bit more natural than VACUUM LIMIT. Opinions?

I personally think VACUUM FOR WRAPAROUND is the best of the options
provided thus far.

Nathan


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Adding CI to our tree
Следующее
От: Arne Roland
Дата:
Сообщение: Re: missing indexes in indexlist with partitioned tables