| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Very busy 24x7 databases and VACUUM |
| Date: | 2004-12-06 21:20:08 |
| Message-ID: | 20041206212008.GL22712@phlogiston.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, Dec 05, 2004 at 11:18:47PM -0500, Christopher Browne wrote:
> One thing that would be somewhat helpful would be to be sure that each
> of the tables that you are vacuuming is handled in a separate
> transaction.
What Chris said. In particular, I've found that pg_autovacuum has
the ability really to kill performance if it starts at the wrong
moment. You need something much more hand-crafted at the moment.
I'll bet, however, that vacuuming some tables more often than once a
day will still be a net win for you.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dedy | 2004-12-07 00:26:18 | test |
| Previous Message | Helena Lourenco | 2004-12-06 16:39:33 | unsubscribe |