ANALYZE might be producing poor stats due to :

i) many dead tuples or
ii) high proportion of dead tuples in the first few pages of the table

Does a VACUUM FULL followed by ANALYZE change the estimates (or have you tried this already)?

(p.s. - I probably don't qualify for the 'more knowledge' bit either...)

You can also increase your statistics_target which will make ANALYZE take longer but can help a great deal
with larger data sets.


Sincerely,

Joshua D. Drake




regards

Mark

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL


---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to