Postgres's Performance degrades after heavy db operation

From: "Preeti Khurana" <preeti(dot)khurana(at)globallogic(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Postgres's Performance degrades after heavy db operation
Date: 2009-06-08 13:38:16
Message-ID: 79CCBF311733CD41A173AD8DB59D4F3601183C56@ex2-del1.synapse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am using Postgresql 8.1.2 and performing quite a huge number of db
operations ( insert/update/ delete) in around 4 tables. Around 3 million
of db is inserted and then 600 K rows are updated for around 5-6 times
during a day. Its observed that running this process for few days ( 5-6
days) makes the db access quite slower. Auto-Vacuum is set to ON with
other parameters set to default.

Slony 1.1.5 is being used for the db replication simultaneously.

Any ideas/pointers on what could be making the DB slow after all these
heavy operations being performed?

Thanks

Preeti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-08 13:50:53 Re: Foreign Key Unique Constraint can be dropped
Previous Message Merlin Moncure 2009-06-08 13:19:23 Re: limit table to one row