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, but the analyze result shows: > > INFO: "[table name]": scanned 30000 of 950145 pages, containing 805842 live > rows and 11109 dead rows; > 30000 rows in sample, 42266462 estimated total rows > > > Even worse estimates. I know that it's doing an estimate, but it's too wrong. > I have another table for > which pg_class estimates 3 times the actual number of rows. > > I'm using 9.1.3 [...]
Could you try with different settings for default_statistics_target (1000, 10000) and see if that changes the result of ANALYZE VERBOSE? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
