PgDog

PgDog is the missing routing layer for PostgreSQL. It moves data between nodes and directs query traffic, transparently to the application.

PgDog operates entirely outside the database and can be deployed in all environments, including managed clouds, like AWS RDS and Google Cloud SQL.

• Route queries: PgDog understands SQL and makes sure queries land on the right shards.
• Move data: Using logical replication, PgDog can shard data in the background without downtime.

Unlock performance previously only available to key/value stores. By adding more data nodes, Postgres becomes as fast as your hardware.

• Share-nothing architecture: Shards are independent databases, with all operations parallelized across the entire cluster.
• Scalable coordinator: Cross-shard queries are supported out of the box. Data relationships are not sacrificed to go faster.