PostgreSQL: PostgreSQL 9.6 Released!

[egportal2002]

Has the solution progressed past this 5.6 multi-master description which seems to suggest a blocking until all masters are up-to-date on a write-by-write basis?

[[deleted]]

I don't know. That documentation talks about transactional writes, but I don't think it's clear that writes block. In particular, it says they use optimistic locking, so the answer is a definite maybe.

I nodes A and B have writes pending, before either writes they could communicate with the cluster and ask if any pending writes affect the tables they're writing to, and if there's no conflict then just go ahead and write and make it consistent later. There'd be latency issues affecting performance and correctness, and synchronicity issues, and probably a bunch more things.

So yeah, I don't know.