alt Hacker NewsHow do you cope with distributed transactions? (I'm not sure if you support them?)
I know that Citus has a `citus_create_restore_point()` (or so) function that, when called, guarantees that no 2PC commits are in flight and creates a WAL restore point in every shard. Therefore, restoring shards to that point will leave the DB in a consistent state. Do you do something similar?
Neki will support cross-shard ACID transactions with a combination of an external transaction coordinator and some changes to PostgreSQL itself to support this (either by engine modifications or extensions).
I expect as part of that, we'll allow users to leverage something similar to make sure that we don't get transaction tearing in backups.