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 with reality.
> The database wi
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 betw
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
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.
