Re: Index oddity

>>
> 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 majordomo@postgresql.org



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