Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Kaare Rasmussen wrote:
>> I consider this a bug, or at least a badly thought out name. I can't
>> understand that someone approved 'reindex database' to mean 'reindex the
>> system tables of a database'.
> Agreed.
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
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
