On Sat, May 31, 2003 at 17:17:38 -0600, Dave E Martin XXIII <[EMAIL PROTECTED]> wrote: > Speaking of which, since the row is locked with select for update (so it > can't be involved in any other transactions anyway) and the change > doesn't change the length of the row, can't it just be updated in-place, > or would that break something else? (pardon if this is answered already, > me thinks its time to go reread the todo's and the architecture > documents...)
No. Select for update only blocks writers, not readers. This has important performance advantages. You might want read the documentation on MVCC. Tom Lane also has a copy of a presentation he made on the web somewhere. I have it read it but it has gotten favorable mention on the lists before. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
