[ADMIN] ANALYZE estimates very wrong reltuples

2013-02-20 Thread Qingbo Zhou
Hi, I have a table which has ~26M records in it. But pg_class shows ~35M in the "reltuples" column. last_autovacuum is null, and last_autoanalyze was just on yesterday. I tried running vacuum analyze on it, but the analyze result shows: INFO: "[table name]": scanned 3 of 950145 pages, conta

Re: [ADMIN] ANALYZE estimates very wrong reltuples

2013-02-20 Thread Qingbo Zhou
Laurenz wrote: > Qingbo Zhou wrote: > > I have a table which has ~26M records in it. But pg_class shows ~35M in > the "reltuples" column. > > last_autovacuum is null, and last_autoanalyze was just on yesterday. > > > > I tried running vacuum analyze on it, bu