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