Fabrízio de Royes Mello <fabriziomello@gmail.com> writes:
> I work with some customer that have databases with a lot of schemas and
> sometimes we need to run manual VACUUM in one schema, and would be nice to
> have a new option to run vacuum in relations from a specific schema.
I'm pretty skeptical of this alleged use-case. Manual vacuuming ought
to be mostly a thing of the past, and even if it's not, hitting
*everything* in a schema should seldom be an appropriate thing to do.
While the feature itself might be fairly innocuous, I'm just wondering
why we need to encourage manual vacuuming. And why that, but not
say schema-wide ANALYZE, CLUSTER, TRUNCATE, ...
regards, tom lane