Den 6 april 2010 14.22 skrev Scott Mead :
>
> 2010/4/6 Björn Lindqvist
>>
>> Den 5 april 2010 11.57 skrev Magnus Hagander :
>> >> 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 re
2010/4/6 Björn Lindqvist
> Den 5 april 2010 11.57 skrev Magnus Hagander :
> >> 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_sta
Den 5 april 2010 11.57 skrev Magnus Hagander :
>> 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, V
2010/4/4 Björn Lindqvist :
> Subject: Completely wrong row estimates
>
> Hello everybody,
>
> Here is the EXPLAIN ANALYZE output for a simple query in my database
> running on postgres 8.3.9:
>
> EXPLAIN ANALYZE
> SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
> WHERE w.word = 'tagt
On 04/05/10 01:44, Björn Lindqvist wrote:
Subject: Completely wrong row estimates
Hello everybody,
Here is the EXPLAIN ANALYZE output for a simple query in my database
running on postgres 8.3.9:
EXPLAIN ANALYZE
SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
WHERE w.word = 'tagt
2010/4/4 Björn Lindqvist :
> Subject: Completely wrong row estimates
>
> Hello everybody,
>
> Here is the EXPLAIN ANALYZE output for a simple query in my database
> running on postgres 8.3.9:
>
> EXPLAIN ANALYZE
> SELECT * FROM word w JOIN video_words vw ON w.id = vw.word_id
> WHERE w.word = 'tagt
