Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.