Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: "Bossart, Nathan" <bossartn@amazon.com>
Cc: "k.jamison@fujitsu.com" <k.jamison@fujitsu.com>, Justin Pryzby <pryzby@telsasoft.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2020-09-17T05:04:01Z
Lists: pgsql-hackers
On Thu, Aug 06, 2020 at 11:50:06AM +0900, Michael Paquier wrote:
> 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.

Seeing nothing happening here, I am marking the CF entry as returned
with feedback.  FWIW, I still tend to think that we could call this
stuff a day if we had an option to skip a toast relation when willing
to vacuum the parent relation.
--
Michael

Commits

  1. Add option PROCESS_TOAST to VACUUM