=?ISO-8859-1?Q?Bj=F6rn_Lindqvist?= writes:
> Den 28 juni 2010 20.22 skrev Tom Lane :
>> But assigning a new value to a column costs something, even if it
>> happens to be equal to the previous value.
> But do I really need to worry about the cost of casting strings to
> ints and other such parsin
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 generally have the following format:
>>>
>>> upd
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 generally have the following format:
>>
>> update foo set a = 1, b = 2, c = 3, where id
Hello
2010/6/28 Björn Lindqvist :
> 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 = 12
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