How does using paxos compare to standard 2PC/XA transactions? Does this only work for append only unique data structures (ex: immutable log style)?
> Does this only work for append only unique data structures (ex: immutable log style)?
Paxos is based on a technique called state machine replication. It replicates an append-only log of changes to an initial state, which allows you to replicate arbitrary data structures. For example, pg_paxos logs SQL commands on a table (e.g. UPDATE).