"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