PostgreSQL 12 High Availability Cookbook - Third Edition

Postgres-XL

While building a sharding API can be educational in some ways, if we're willing to embrace a bit of vendor lock-in, there's an alternative. Postgres-XL is a fork of core PostgreSQL that incorporates a lot of sharding concepts by distributing data to separately allocated data nodes. It is currently maintained primarily by 2ndQuadrant, and is available at https://www.postgres-xl.org/.

As with CitusDB, some features are restricted, but they are fewer in number. Generally, each node acts with nearly the full feature set of a standard PostgreSQL 10 installation. The main drawback to using this platform is that it requires a lot of manual setup: data nodes, coordinator nodes, and GTM nodes, along with GTM proxies, must all be installed ...