Обсуждение: 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.
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. -- Adrian Klaver adrian.klaver@aklaver.com
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 between actual row count and and the current statistics row count, you can decide if you need to vacuum analyze or delay.On Thu, Nov 12, 2015 at 1:02 PM, anj patnaik <patna73@gmail.com> wrote:
I get this warning when trying to fetch data for a postgres db. Does this indicate a real issue? ThanksRunning VACUUM recommendedThe estimated rowcount on the table "recorder" deviates significantly from the actual rowcount. You should run VACUUM ANALYZE on this table.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
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.
--