Seems synchronous_commit = off doesn't work with PREPARE TRANSACTION command. #PostgreSQL
I don't see how it'd make sense to apply sc=off to 2PC. Using 2PC PREP XACT is explicitly asking for the guarantee to be able to commit/rollback later, sc=off wouldn't fulfill that.
-
-
That'd basically be fsync=off.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Maybe. But if such guarantee is necessary, sc should be just set to >local. I'm not sure if it's ok to use 2PC with sc=off. Anyway I was just a bit surprised at that because it's first time to see that code.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.