postgres getting slow under heavy load though autivacuum is enabled

From: "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: postgres getting slow under heavy load though autivacuum is enabled
Date: 2009-06-09 08:37:15
Message-ID: 68666423656E1444A011106C4E085F4D01954F@ex3-del1.synapse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I am using postgres 8.1.2 with slony 1.1.5 used for replication between two nodes. Very high number of db operations like (2.8 million inserts, 1.4 million update and 4.5 lakhs deletes.) are being done on db in one transaction and this is repeated for 5-6 times a day at an interval of let say 2 hours. This process is runnning for 5 consective days. It is obeserved that db is getting very slow with time. The number of dead tuples getting increased in pg_listener, sl_log_1 and sl_seqlog tables with time though I have autovacuum enabled and slony related tables like (sl_log_1 , sl_seqlog etc) are configured not to be processed by autovacuum . Please let me know what could be the reason of increasing dead tuples in these tables and postgres getting slow.

Thanks..
Tamanna

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2009-06-09 11:32:50 Text search without dictionary ?
Previous Message Dave Page 2009-06-09 08:14:46 Re: Can postgresql store its data on raw device now?