From: | Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange performance degradation |
Date: | 2009-11-20 09:43:40 |
Message-ID: | 4B0664CC.9010809@forinicom.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Hi all,
I'm experiencing a strange behavior with my postgresql 8.3:
performance is degrading after 3/4 days of running time but if I
just restart it performance returns back to it's normal value..
In normal conditions the postgres process uses about 3% of cpu time
but when is in "degraded" conditions it can use up to 25% of cpu time.
The load of my server is composed of many INSERTs on a table, and
many UPDATEs and SELECT on another table, no DELETEs.
I tried to run vacuum by the pg_maintenance script (Debian Lenny)
but it doesn't help. (I have autovacuum off).
So, my main question is.. how can just a plain simple restart of postgres
restore the original performance (3% cpu time)?
I can post my postgresql.conf if needed.
Thank you for your help,
--
Lorenzo
From | Date | Subject | |
---|---|---|---|
Next Message | nicola zandonà | 2009-11-20 09:48:16 | how to use a cursor for update? |
Previous Message | Allan Kamau | 2009-11-20 09:42:16 | Re: Allowing for longer table names (>64 characters) |
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2009-11-20 10:23:22 | Re: Strange performance degradation |
Previous Message | Tom Lane | 2009-11-20 07:08:10 | Re: Partitions and max_locks_per_transaction |