Re: slower every day

Am Mittwoch, 1. September 2004 12:06 schrieb G u i d o B a r o s i o:
>   The problem is the time that the postgres takes to perform/return a
> query. For example, trying the \d <tablename> command takes between 4 or 5
> seconds. This table is very big, but I am not asking for the rows, only
> asking the table schema, so...why is this so slow?!?!? My last
> administrative action into this table was a reindex to all the indexes via
> the BKI in standalone mode. I thought I suceed, but this was las saturday.

Do you regularly vacuum and analyze the database?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/