Horizontally distributed PostgreSQL v.s. multi-master replication

How does Citus compare to Spock? With Citus, you get more of a data warehouse approach. If you have a lot of data that you need to quickly build reports out of, Citus helps you distribute the information across hardware for faster retrieval times. Spock allows you to read and write to the same datasets from multiple locations - whether across continents, or across cloud vendors - in a manner that localizes those reads and writes. The result: reduced latency and more reliable connections to your app, no matter where the user is. Both open-source solutions for PostgreSQL, but different use cases. Shaun Thomas discusses this difference in more depth in the video. What kind of a difference would reliable multi-master replication make in your setup? Check out Spock on GitHub: https://github.com/pgEdge/spock Or learn more about pgEdge on our website: https://pgedge.com Citus can also be found on GitHub: https://github.com/citusdata/citus #github #mmr #postgres #postgresql #opensource #data #tech #techtips #technology #datawarehouse