On Wed, Aug 05, 2020 at 12:56:48AM +0000, Bossart, Nathan wrote: > My main motive for adding the MAIN_RELATION_CLEANUP option is to allow > table owners to easily vacuum only a relation's TOAST table. Roles do > not have access to the pg_toast schema by default, so they might be > restricted from vacuuming their TOAST tables directly.
True that you need an extra GRANT USAGE ON pg_toast to achieve that for users with no privileges, but that's not impossible now either. I am not sure that this use-case justifies a new option and more complications in the code paths of vacuum though. So let's see first if others have an opinion to offer. -- Michael