3 ms·
Synchronous replication was added in 9.1 and much improved in 9.6? pglogical[0] works pretty well for me under 10 but I have no production experience with bdr[
by shawn-butler 9y ago
Synchronous replication was added in 9.1 and much improved in 9.6? pglogical[0] works pretty well for me under 10 but I have no production experience with bdr[1].
[0]: https://www.2ndquadrant.com/en/resources/pglogical/ https://www.2ndquadrant.com/en/resources/pglogical/
[1]: https://www.2ndquadrant.com/en/resources/bdr/ https://www.2ndquadrant.com/en/resources/bdr/
- elvinyung 9y agoIMO, sure but it's far from seamless. (I also looked at pg's quorum commits, but the same applies.) In general Postgres was not designed at its core for a distributed world. Even now, replication feels like an afterthought in the grand scheme of things, and sharding nonexistent without extensions.