Horton

Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM

Vik Fearing <vik.fearing@2ndquadrant.com>

View thread View on postgr.es
From: Vik Fearing <vik.fearing@2ndquadrant.com>
To: "Bossart, Nathan" <bossartn@amazon.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2020-01-21T21:38:20Z
Lists: pgsql-hackers 
On 21/01/2020 22:21, Bossart, Nathan wrote:
> I've attached a patch for a couple of new options for VACUUM:
> MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP.  The motive
> behind these options is to allow table owners to easily vacuum only
> the TOAST table or only the main relation.  This is especially useful
> for TOAST tables since roles do not have access to the pg_toast schema
> by default and some users may find it difficult to discover the name
> of a relation's TOAST table.


Could you explain why one would want to do this?  Autovacuum will
already deal with the tables separately as needed, but I don't see when
a manual vacuum would want to make this distinction.

-- 

Vik Fearing

Commits

  1. Add option PROCESS_TOAST to VACUUM