From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: vacuum and routine maintenance docs |
Date: | 2006-01-18 23:28:51 |
Message-ID: | Pine.LNX.4.64.0601181522180.20291@glacier.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Wed, 18 Jan 2006, Scott Marlowe wrote:
> Well, I'm kind of tempted to rewrite the whole section. I'd like to
> come up with some objectives of what we're trying to cover there, and
> basically start over with all the information that's there plus the
> other stuff on fsm and mvcc as it applies to vacuum, or link to it as
> needed.
A couple questions I find difficult to answer using the online docs are:
* Is my autovacuum doing a good enough job?
* What percentage of bloat is reasonable (and how can I tell what my bloat
level is)?
* What transaction loads would require specific autovacuum settings, or manual
vacuum fulls?
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-01-19 00:55:07 | Re: vacuum and routine maintenance docs |
Previous Message | Scott Marlowe | 2006-01-18 23:13:28 | Re: vacuum and routine maintenance docs |