Postgres Pro
Downloads
Home   >   mailing lists

Postgres's Performance degrades after heavy db operation - Mailing list pgsql-general

From Preeti Khurana
Subject Postgres's Performance degrades after heavy db operation
Date
Msg-id 79CCBF311733CD41A173AD8DB59D4F3601183C56@ex2-del1.synapse.com
Whole thread Raw
Responses Re: Postgres's Performance degrades after heavy db operation
Re: Postgres's Performance degrades after heavy db operation
Re: Postgres's Performance degrades after heavy db operation
List pgsql-general
Tree view

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

 

pgsql-general by date:

Previous
From: Kevin Field
Date:
Subject: Re: trigger functions with arguments
Next
From: "Anirban Pal"
Date:
Subject: Re: Why lots of temp schemas are being created