On Thu, Aug 31, 2017 at 9:53 PM, Kyotaro HORIGUCHI <[email protected]> wrote: > I sometimes feel annoyed when trying to VACUUM multiple specific > tables. > > postgres=# vacuum a, b; > ERROR: syntax error at or near "," > LINE 1: vacuum a, b; > > This patch just allows multiple targets for VACUUM command.
There is a patch for the same feature by Nathan Bossart which is being discussed already in this commit fest: https://www.postgresql.org/message-id/[email protected] It had already a couple of rounds of reviews, and is getting close to something that could be committed. There is still a pending bug related to the use of RangeVar though with autovacuum. Your approach is missing a couple of points. For example when specifying multiple targets, we have decided to check for an ERROR at the beginning of VACUUM, but we are issuing a WARNING if it goes missing in the middle of processing a list, so your set of patches would provide a frustrating experience. We have also discussed about reshaping a bit the API of vacuum(), so I would recommend looking at what has been already proposed if you are interested. -- Michael -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
