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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to