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

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

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

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)