| From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, MirrorX <mirrorx(at)gmail(dot)com> |
| Subject: | Re: weird table sizes |
| Date: | 2011-07-24 18:54:27 |
| Message-ID: | CAKt_ZfuvXL_WazDz3iDaVK0MqH=dz=4FSzEe7uVrFbXb1ykpyA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Jul 24, 2011 at 11:45 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> 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.
>
Are these on the same server or different servers?
Is it possible that there is database bloat on the second? How many
rows do you (roughly) expect? is that estimate reasonable?
Best wishes,
Chris Travers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-07-24 20:28:23 | Re: streaming replication does not work across datacenter with 20ms latency? |
| Previous Message | Adrian Klaver | 2011-07-24 18:45:49 | Re: weird table sizes |