Re: add PROCESS_MAIN to VACUUM - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: add PROCESS_MAIN to VACUUM
Date
Msg-id c26c617bfc9e088c883624d059d34c983374f098.camel@j-davis.com
Whole thread Raw
In response to add PROCESS_MAIN to VACUUM  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: add PROCESS_MAIN to VACUUM
List 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 by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX
Next
From: Nathan Bossart
Date:
Subject: Re: add PROCESS_MAIN to VACUUM