From: | G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | slower every day |
Date: | 2004-09-01 10:06:22 |
Message-ID: | 20040901100622.501786C4EA@tino.sinectis.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
Dear all,
I am currently experiencing troubles with the performance of my critical's database.
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. Today I am in the same situation again.
The only change that I've done was a highest level of debug in the conf file (loggin lot of stuff).
I understand that this could lack on performance, but when I've changed the .conf file to the usual .conf file (with less debug), and pg_ctl reload(ed) it, it goes on debuging as in the first state, in the higher level. Is this a known issue?
My conclusion is that I can aquire high levels of debug while the server is running, editing the .conf file, and pg_reload(ing) it, but I can go back then, unless I pg_restart the server. Is this ok?
Some info
-----------------------------------------------------------
PostgreSQL 7.4.2
[postgres(at)lmnukmis02 data]$ pg_config --configure
'--enable-thread-safety' '--with-perl'
Intel(R) Xeon(TM) MP CPU 2.80GHz
Linux 2.4.24-ck1 #5 SMP Fri Mar 12 23:41:51 GMT 2004 i686 unknown
RAM 4 Gb.
-----------------------------------------------------------
Thanks, Guido.
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2004-09-01 10:25:36 | Re: slower every day |
Previous Message | Gémes Géza | 2004-08-31 10:09:35 | Re: help on automatically running sql files |
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2004-09-01 10:25:36 | Re: slower every day |
Previous Message | Stefano Bonnin | 2004-09-01 09:18:52 | Re: Query performance issue with 8.0.0beta1 |