On Thu, Aug 31, 2017 at 9:53 PM, Kyotaro HORIGUCHI <horiguchi.kyot...@lab.ntt.co.jp> 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/e061a8e3-5e3d-494d-94f0-e8a9b312b...@amazon.com 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
