Jan Wieck <JanWieck@Yahoo.com> 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