Re: BUG #10823: Better REINDEX syntax. - Mailing list pgsql-bugs

Bruce Momjian <bruce@momjian.us> writes:
> On Tue, Jul  1, 2014 at 10:33:07AM +0000, dmigowski@ikoffice.de wrote:
>> Compared to CLUSTER and VACUUM FULL we need to specify a database to the
>> REINDEX command. Why? It would be logical to reindex the current database,
>> exactly like CLUSTER does. So why isn't the DATABASE parameter optional?

> Wow, yeah, that is kind of odd, e.g.

I don't find it all that odd.  We should not be encouraging routine
database-wide reindexes.

            regards, tom lane