Re: add PROCESS_MAIN to VACUUM

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>

To: Nathan Bossart <nathandbossart@gmail.com>, pgsql-hackers@postgresql.org

Date: 2023-01-13T23:24:09Z

Lists: 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

Commits

Improve readability of code PROCESS_MAIN in vacuum_rel()
- ee56048b0ecf 16.0 landed
Add PROCESS_MAIN to VACUUM
- 4211fbd8413b 16.0 landed
Improve the regression tests of VACUUM (PROCESS_TOAST)
- 46d490ac19a7 16.0 landed
Display the leader apply worker's PID for parallel apply workers.
- d540a02a724b 16.0 cited