Bruce Momjian <[EMAIL PROTECTED]> writes: > Let me add that outside transactions read those phantom xid only when > they are doing dirty reads. What I don't understand is when do outside > transactions see tuples created inside a transaction? INSERT into a > table with a unique key?
> Once the main transaction commits, these phantom tuples should work just > like ordinary tuples except they get their cmin overwritten when they > are expired, I think. You're not doing anything to increase my confidence level in this concept. You invented it, and even you aren't sure how it works. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings