Search Postgresql Archives

Re: Postgres's Performance degrades after heavy db operation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2009/6/10 Preeti Khurana <preeti.khurana@xxxxxxxxxxxxxxx>:
> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux