From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | gbarosio(at)uolsinectis(dot)com(dot)ar |
Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: slower every day |
Date: | 2004-09-01 10:28:48 |
Message-ID: | 200409011228.48793.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | G u i d o B a r o s i o | 2004-09-01 10:57:15 | Re: slower every day |
Previous Message | Shridhar Daithankar | 2004-09-01 10:25:36 | Re: slower every day |
From | Date | Subject | |
---|---|---|---|
Next Message | G u i d o B a r o s i o | 2004-09-01 10:57:15 | Re: slower every day |
Previous Message | Shridhar Daithankar | 2004-09-01 10:25:36 | Re: slower every day |