Re: weird table sizes - Mailing list pgsql-general

From Adrian Klaver
Subject Re: weird table sizes
Date
Msg-id 201107241145.50357.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: weird table sizes  (MirrorX <mirrorx@gmail.com>)
Responses Re: weird table sizes
List pgsql-general
On Saturday, July 23, 2011 3:34:07 pm MirrorX wrote:
> i mentioned the sequences number only b/c it seemed stange and i didnt know
> if it could be related to the "weird" sizes.
>
> now i found something more weird...the autovacuum is ON but on
> pg_stat_user_tables on this specific table tha last_vacuum and
> last_autovacuum are both NULL...how can this happen?

Old stats?  Try manually running ANALYZE against the table.

>
>
> thx a lot for all the help
>


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Chris Travers
Date:
Subject: Re: weird table sizes