Re: vacuum and routine maintenance docs - Mailing list pgsql-docs

From Jeff Frost
Subject Re: vacuum and routine maintenance docs
Date
Msg-id Pine.LNX.4.64.0601181522180.20291@glacier.frostconsultingllc.com
Whole thread Raw
In response to Re: vacuum and routine maintenance docs  (Scott Marlowe <smarlowe@g2switchworks.com>)
List 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@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-docs by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: vacuum and routine maintenance docs
Next
From: Tom Lane
Date:
Subject: Re: vacuum and routine maintenance docs