[GENERAL] get this warning from pgAdmin

I get this warning when trying to fetch data for a postgres db. Does this indicate a real issue? Thanks Running VACUUM recommended The estimated rowcount on the table "recorder" deviates significantly from the actual rowcount. You should run VACUUM ANALYZE on this table.

Re: [GENERAL] get this warning from pgAdmin

2015-11-12 19:43 GMT+01:00 Adrian Klaver : > 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

Re: [GENERAL] get this warning from pgAdmin

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

Re: [GENERAL] get this warning from pgAdmin

This is not necessarily a major issue. It is simply an advisory that a significant number of rows in the table have been inserted, updated or deleted and that in order to have reliable statistics, a vacuum analyze should be done. Depending on the number of rows in the table and the difference