| From: | Tobias Brox <tobias(at)nordicbet(dot)com> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Edoardo Ceccarelli <eddy(at)axa(dot)it>, postgres performance list <pgsql-performance(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Date: | 2006-10-15 09:52:59 |
| Message-ID: | 20061015095259.GA24002@oppetid.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
[Matthew T. O'Connor - Wed at 02:33:10PM -0400]
> In addition autovacuum respects the work of manual or cron based
> vacuums, so if you issue a vacuum right after a daily batch insert /
> update, autovacuum won't repeat the work of that manual vacuum.
I was experimenting a bit with autovacuum now. To make the least effect
possible, I started with a too high cost_delay/cost_limit-ratio. The
effect of this was that autovacuum "never" finished the transactions it
started with, and this was actually causing the nightly vacuum to not do
it's job good enough.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2006-10-15 14:42:34 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Previous Message | Mohamed Yassin Eltabakh | 2006-10-14 17:51:58 | Modifying Makefile |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2006-10-15 14:42:34 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Previous Message | Mischa Sandberg | 2006-10-14 21:18:45 | Re: [HACKERS] Hints proposal |