Den 28 juni 2010 20.22 skrev Tom Lane :
> Pavel Stehule writes:
>> 2010/6/28 Björn Lindqvist :
>>> My question is like the subject, is it much slower to update all
>>> columns values than just a single column? Generated update queries
>>> from ORM:s
Hello everyone,
My question is like the subject, is it much slower to update all
columns values than just a single column? Generated update queries
from ORM:s generally have the following format:
update foo set a = 1, b = 2, c = 3, where id = 1234;
So each column is touched which, I suspect
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 rea
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
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 = 'tagtext';
QUERY PLAN
--
