Jan Wieck <[EMAIL PROTECTED]> writes: > The other problem I was missing being addressed is what happens if one > promised "I can commit" and crashes? Not exactly at the time he crashes, > but more at the time he restarts? Doesn't he have to restart into > exactly that state of "I can commit", with all locks in place
Yes, I think he does --- which adds a whole 'nother layer of complexity and performance penalty to the thing, because all those held locks etc have to be recorded on disk before you promise to commit. That part is soluble in theory though, ie, I believe that it can be done (not efficiently, but it can be done). I don't see what to do about the no-commit-ack problem. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org