Re: Suboptimal plan choice problem with 8.3RC2 - Mailing list pgsql-hackers

Guillaume Smet escribió:

> It seems that autovacuum took care of them just after the import which
> is what I expected:

[...]

> So I wonder why the stats were so bad... I didn't update the data at
> all after the initial import. Any idea?

Hmm, perhaps the analyze was done with the default statistic target (10)?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support