Re: slower every day

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/

In response to

Browse pgsql-admin by date

  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

Browse pgsql-performance by date

  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