| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | anj patnaik <patna73(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: get this warning from pgAdmin |
| Date: | 2015-11-12 18:43:53 |
| Message-ID: | 5644DDE9.7060709@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2015-11-12 18:49:37 | Re: can postgres run well on NFS mounted partitions? |
| Previous Message | anj patnaik | 2015-11-12 18:19:39 | Re: can postgres run well on NFS mounted partitions? |