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  (Antoine <melser.anton@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: n00b autovacuum question
Следующее
От: Chris Travers
Дата:
Сообщение: Re: firebird X postgresql 8.1.2 windows, performance comparison