> They get the location they ask for, or a failure. Hunting around for
> the new tuple seems like a real waste, and if someone vacuums, it is
> gone, no?
It is probably worse, since they might even get the wrong row,
but that's the same in Informix and Oracle.
In Informix:
a: selects rowid
b: updates row, row grows, does not fit in page, is relocated
c: inserts rows, pysical location of rowid is reused
a: selects row by rowid, gets differet row --> bummer
Andreas