Strange performance degradation

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

Responses

Browse pgsql-general by date

  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)

Browse pgsql-performance by date

  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