Re: The Contrib Roundup (long) - Mailing list pgsql-hackers

"Marc G. Fournier" <scrappy@postgresql.org> writes:
> On Sat, 11 Jun 2005, Tom Lane wrote:
>> It's always bothered me too.  How about
>> 
>> REINDEX SYSTEM -> system tables (current meaning of R. DATABASE)
>> REINDEX USER -> all non-system tables
>> REINDEX DATABASE -> both of the above

> Why all the choices?  What cases are there for doing one without the 
> other?  If you want to get 'fine tuned', do a 'REINDEX TABLE' ... I can 
> see REINDEX SYSTEM and REINDEX DATABASE (includes SYSTEM), but not the 
> USER one ..

The main argument I can think of for REINDEX USER is that it could be
executed by someone who isn't necessarily superuser.  Not sure how
important that is, though.
        regards, tom lane