Summary
In this chapter, we dealt with Postgres-XC, a distributed version of PostgreSQL that is capable of horizontal partitioning and query distribution. The goal of the Postgres-XC project is to have a database solution capable of scaling out writes transparently. It offers a consistent view of the data and various options for distributing data inside the cluster.
It is important to know that Postgres-XC is not just a simple add-on of PostgreSQL, but a fully compliant code fork.
The next chapter will cover PL/Proxy, a tool used to shard PostgreSQL database systems. You will learn how to distribute data to various nodes and shard it to handle large setups.
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
