2015-11-12 19:43 GMT+01:00 Adrian Klaver <adrian.kla...@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. -- Guillaume. http://blog.guillaume.lelarge.info http://www.dalibo.com