> Well, it can do lots stuff that DROP/CREATE CONCURRENTLY can't:
> * reindex primary keys
> * reindex keys referenced by foreign keys
> * reindex exclusion constraints
> * reindex toast tables
> * do all that for a whole database
> so I don't think that comparison is fair. Having it would have made
> several previous point releases far less painful (e.g. 9.1.6/9.2.1).
FWIW, I have a client who needs this implementation enough that we're
backporting it to 9.1 for them.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com