Re: [GENERAL] Postgres's Performance degrades after heavy db operation

[Preeti Khurana]

I checked the release notes till 8.1.17, but could not come across any such 
issue which leads to db performance degradation after doing heavy db 
operations. AutoVacuum is also enabled parallel.



-Original Message-
From: Grzegorz Jaśkiewicz [mailto:gryz...@gmail.com] 
Sent: Monday, June 08, 2009 9:59 PM
To: Preeti Khura
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres's Performance degrades after heavy db operation

oh, and take the time to upgrade to newest 8.1.X as the matter of urgency!.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Postgres's Performance degrades after heavy db operation

[Preeti Khurana]

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