Re: add PROCESS_MAIN to VACUUM

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: add PROCESS_MAIN to VACUUM
Дата
Msg-id c26c617bfc9e088c883624d059d34c983374f098.camel@j-davis.com
обсуждение исходный текст
Ответ на add PROCESS_MAIN to VACUUM  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: add PROCESS_MAIN to VACUUM  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-hackers
On Thu, 2022-12-29 at 16:00 -0800, Nathan Bossart wrote:
> The motivation for adding this option is to make it easier to VACUUM
> only a
> relation's TOAST table.  At the moment, you need to find the TOAST
> table by
> examining a relation's reltoastrelid, and you need USAGE on the
> pg_toast
> schema.  This option could also help make it possible to call only
> vac_update_datfrozenxid() without processing any relations, as
> discussed
> elsewhere [2].

For completeness, did you consider CLUSTER and REINDEX options as well?


--
Jeff Davis
PostgreSQL Contributor Team - AWS





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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: add PROCESS_MAIN to VACUUM