On Sun, Oct 12, 2014 at 1:27 PM, Stephen Frost <sfr...@snowman.net> wrote: > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: >> Sawada Masahiko wrote: >> > Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing >> > all table of specified schema. >> > There are syntax dose reindexing specified index, per table and per >> > database, >> > but we can not do reindexing per schema for now. >> >> It seems doubtful that there really is much use for this feature, but if >> there is, I think a better syntax precedent is the new ALTER TABLE ALL >> IN TABLESPACE thingy, rather than your proposed REINDEX SCHEMA. >> Something like REINDEX TABLE ALL IN SCHEMA perhaps. > > Yeah, I tend to agree that we should be looking at the 'ALL IN > TABLESPACE' and 'ALL IN SCHEMA' type of commands to keep things > consistent. This might be an alternative for the vacuum / analyze / > reindex database commands also..
Urgh. I don't have a problem with that syntax in general, but it clashes pretty awfully with what we're already doing for REINDEX otherwise. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers