Re: [GENERAL] column updates

2004-10-29 Thread Ben
Thanks. Good to hear that the easiest solution for me is also the fastest. On Fri, 29 Oct 2004, Martijn van Oosterhout wrote: > The number of dead tuples is the number of UPDATE statements you make. > You if you just do a straight UPDATE x set f1=x, f2=y, ... that will be > as optimal as you can

Re: [GENERAL] column updates

2004-10-29 Thread Martijn van Oosterhout
The number of dead tuples is the number of UPDATE statements you make. You if you just do a straight UPDATE x set f1=x, f2=y, ... that will be as optimal as you can get. The only exception may be toasted fields, which would only apply if you had fields with more than 2K of data or so... Hope this