Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

Next:From: A. KretschmerDate: 2009-11-20 10:23:22
Subject: Re: Strange performance degradation
Previous:From: Tom LaneDate: 2009-11-20 07:08:10
Subject: Re: Partitions and max_locks_per_transaction

pgsql-general by date

Next:From: nicola zandonàDate: 2009-11-20 09:48:16
Subject: how to use a cursor for update?
Previous:From: Allan KamauDate: 2009-11-20 09:42:16
Subject: Re: Allowing for longer table names (>64 characters)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group