Re: n00b autovacuum question

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: n00b autovacuum question
Дата
Msg-id 441C4758.9000205@pse-consulting.de
обсуждение исходный текст
Ответ на n00b autovacuum question  (Antoine <melser.anton@gmail.com>)
Ответы Re: n00b autovacuum question
Список pgsql-performance
Antoine wrote:
> Hi,
> I have enabled the autovacuum daemon, but occasionally still get a
> message telling me I need to run vacuum when I access a table in
> pgadmin.

pgAdmin notices a discrepancy between real rowcount and estimated
rowcount and thus suggests to run vacuum/analyze; it won't examine
autovacuum rules so it might warn although autovac is running ok.

If you're sure autovacuum is running fine, just dismiss the message.
It's a hint for newbies that do *not* run vacuum because they don't know
what it's good for.

Regards
Andreas

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