Re: [ADMIN] Transactions, tuples, and VACUUM

2003-08-14 Thread Tom Lane
Matt Clark [EMAIL PROTECTED] writes: consider: begin; update a set col1 = 'p' where id = '1'; update a set col2 = 'q' where id = '1'; commit; versus: update a set col1 = 'p', col2 = 'q' where id = '1'; Does the first case generate any more dead tuples that will need vacuuming

[ADMIN] Transactions, tuples, and VACUUM

2003-08-14 Thread Matt Clark
Morning all, bit of a general question here... consider: begin; update a set col1 = 'p' where id = '1'; update a set col2 = 'q' where id = '1'; commit; versus: update a set col1 = 'p', col2 = 'q' where id = '1'; Does the first case generate any more dead tuples that will need