Den 6 april 2010 14.22 skrev Scott Mead <scott.lists@enterprisedb.com>:
>
> 2010/4/6 Björn Lindqvist <bjourne@gmail.com>
>>
>> Den 5 april 2010 11.57 skrev Magnus Hagander <magnus@hagander.net>:
>> >> Note how the planner estimates that there are 766 rows in the table
>> >> that matches the word 'tagtext'. In reality 43374 does. I've tried to
>> >> get postgres to refresh the statistics by running with
>> >> enable_statistics_target=100, running VACUUM, VACUUM FULL, VACUUM FULL
>> >> ANALYZE etc but nothing works. Postgres seem stuck with its bad
>> >> statistics and unwilling to change them. There are many other strings
>> >> that also matches tens of thousands of rows in the table which
>> >> postgres only thinks matches 766.
>
> Have you tried running :
> 'EXPLAIN ANALYZE <your query>'
> ?
> This will show you the estimates and the actuals (for each operation) side
> by side.
Yes, see my first message where I post the EXPLAIN ANALYZE output for the query.
--
mvh Björn