Re: vacuum and routine maintenance docs

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: vacuum and routine maintenance docs
Дата
Msg-id Pine.LNX.4.64.0601181522180.20291@glacier.frostconsultingllc.com
обсуждение исходный текст
Ответ на Re: vacuum and routine maintenance docs  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: vacuum and routine maintenance docs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: vacuum and routine maintenance docs