Re: weird table sizes

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: MirrorX <mirrorx(at)gmail(dot)com>
Subject: Re: weird table sizes
Date: 2011-07-24 18:45:49
Message-ID: 201107241145.50357.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2011-07-24 18:54:27 Re: weird table sizes
Previous Message Yan Chunlu 2011-07-24 16:20:15 Re: streaming replication does not work across datacenter with 20ms latency?