| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Preeti Khurana <preeti(dot)khurana(at)globallogic(dot)com> |
| Cc: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres's Performance degrades after heavy db operation |
| Date: | 2009-06-10 08:31:47 |
| Message-ID: | dcc563d10906100131w298fe59cldd4ee830b4539bb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/6/10 Preeti Khurana <preeti(dot)khurana(at)globallogic(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pedro Doria Meunier | 2009-06-10 10:26:54 | Average connections |
| Previous Message | Preeti Khurana | 2009-06-10 07:25:34 | Re: Postgres's Performance degrades after heavy db operation |