Re: [GENERAL] Is full-row updates slower than single-value updates

2010-07-01 Thread Tom Lane
=?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

Re: [GENERAL] Is full-row updates slower than single-value updates

2010-07-01 Thread Björn Lindqvist
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

Re: [GENERAL] Is full-row updates slower than single-value updates

2010-06-28 Thread 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: >> >> update foo set a = 1, b = 2, c = 3, where id

Re: [GENERAL] Is full-row updates slower than single-value updates

2010-06-28 Thread Pavel Stehule
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

[GENERAL] Is full-row updates slower than single-value updates

2010-06-28 Thread 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 = 1234; So each column is touched which, I suspect