VACUUM vs auto-vacuum daemon

Поиск
Список
Период
Сортировка
От Sabin Coanda
Тема VACUUM vs auto-vacuum daemon
Дата
Msg-id f4mfin$1vjf$1@news.hub.org
обсуждение исходный текст
Ответы Re: VACUUM vs auto-vacuum daemon  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: VACUUM vs auto-vacuum daemon  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
Hi there,

Using explicitly VACUUM command give me the opportunity to fine tune my
VACUUM scheduling parameters, after I analyze the log generated by VACUUM
VERBOSE.

On the other hand I'd like to use the auto-vacuum mechanism because of its
facilities. Unfortunately, after I made some initial estimations for
autovacuum_naptime, and I set the specific data into pg_autovacuum table, I
have not a feedback from the auto-vacuum mechanism to check that it works
well or not.  It would be nice to have some kind of log similar with the one
generated by VACUUM VERBOSE. Is the auto-vacuum mechanism able to provide
such a useful log ?

TIA,
Sabin



В списке pgsql-performance по дате отправления:

Предыдущее
От: Vladimir Stankovic
Дата:
Сообщение: Re: Variable (degrading) performance
Следующее
От: "Tyrrill, Ed"
Дата:
Сообщение: Re: Best way to delete unreferenced rows?