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
-
Add option PROCESS_TOAST to VACUUM
- 7cb3048f38e2 14.0 landed