2009/6/10 Preeti Khurana <preeti.khur...@globallogic.com>: > 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.
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general