I'm reading the description of PREPARE TRANSACTION, and I see this:
"...its state is fully stored on disk, and there is a very high probability that it can be committed successfully..."
What corner case reduces 2pc from "guaranteed" to "very high probability"? Is the worry if somebody leaves transactions in a prepared state for weeks, only to find that deadlock issues has arrisen at final commit time?
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/