pgadmin "Running VACUUM recommended"

Поиск
Список
Период
Сортировка
От Anibal David Acosta
Тема pgadmin "Running VACUUM recommended"
Дата
Msg-id 000b01cc2b97$0c39c370$24ad4a50$@devshock.com
обсуждение исходный текст
Ответы Re: pgadmin "Running VACUUM recommended"
Список pgsql-general

Hello, I have installed postgres 9.0 that is supposed has by default auto vacuum enabled

 

But sometimes when I click over a table in the pgadmin, this application recommend me to vacuum

The message is:

“The estimated rowcount on the table XXX deviates significantly from the actual rowcount. You should run VACUUM ANALYZE on this table.

 

Why this happened? The auto vacuum is not doing a good job?

 

Thanks

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

Предыдущее
От: Nigel Heron
Дата:
Сообщение: blks_read/blks_hit stats
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgadmin "Running VACUUM recommended"