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

From Scott Marlowe
Subject Re: Postgres's Performance degrades after heavy db operation
Date
Msg-id dcc563d10906100131w298fe59cldd4ee830b4539bb@mail.gmail.com
Whole thread Raw
In response to Re: Postgres's Performance degrades after heavy db operation  ("Preeti Khurana" <preeti.khurana@globallogic.com>)
List pgsql-general
2009/6/10 Preeti Khurana <preeti.khurana@globallogic.com>:
> I checked the release notes till 8.1.17, but could not come across any such issue which leads to db performance
degradationafter doing heavy db operations. AutoVacuum is also enabled parallel. 

Note that you might be much better served moving to 8.3 if HOT can
help with your usage patterns.  A database I work with dropped in load
by about 1/2 (maybe a bit more) just by switching to 8.3.  But it's
not magic pixie dust and if your usage patterns preclude HOT helping
(i.e. updating every row in a table) then I don't expect any miracles.

pgsql-general by date:

Previous
From: "Preeti Khurana"
Date:
Subject: Re: Postgres's Performance degrades after heavy db operation
Next
From: Bill Moran
Date:
Subject: Re: Postgres's Performance degrades after heavy db operation