Re: get this warning from pgAdmin

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: get this warning from pgAdmin
Дата
Msg-id CAECtzeVqrZQSatiHegx8DaD9p2KFSWqzed2j2sPiEqd5c+1GGg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: get this warning from pgAdmin  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
2015-11-12 19:43 GMT+01:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 11/12/2015 10:02 AM, anj patnaik wrote:
I get this warning when trying to fetch data for a postgres db. Does
this indicate a real issue? Thanks

Well it means the statistics for the table are out of touch with reality. The database will not fall over, but your queries against the table will be using stale statistics when the query planner sets up the query.


Running VACUUM recommended
The estimated rowcount on the table "recorder" deviates significantly
from the actual rowcount. You should run VACUUM ANALYZE on this table.

I would take the suggestion, or you can wait till autovacuum hits the table.


AFAIK, this part of the code in pgAdmin hasn't been touched since quite a few years. You shouldn't rely on it to know which tables need a VACUUM or an ANALYZE.


--

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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: get this warning from pgAdmin
Следующее
От: John McKown
Дата:
Сообщение: Re: can postgres run well on NFS mounted partitions?