Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > One idea Simon and I had was to reuse heap rows where all indexed values > > in the old row and the new row were the same, meaning the heap value > > could be replaced without changing the indexes at all. We thought this > > would be very useful for frequently-updated rows. It could also be used > > if no index are on the table. > > MVCC goes out the window, eh? Not to mention transaction rollback ability?
If the old row is not visible to any transactions, why would it not work? -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
