PgDog

A PostgreSQL proxy that combines connection pooling, load balancing, and distributed database sharding into a single executable, solving scalability and performance problems for Postgres. It targets developers and engineering teams managing large-scale Postgres deployments in companies of all sizes. The solution is positioned as a drop-in proxy requiring no application changes, deployable anywhere via Helm, Docker, or directly, and maintains ACID compliance with features like cross-shard transactions and failover detection.

Key features

• Real transaction mode connection pooling
• Supports SET commands, advisory locks, LISTEN/NOTIFY
• Multi-threaded and async (50k+ transactions/s per thread)
• Prepared statements with zero overhead
• Health checks for replicas
• Failover detection and primary election
• Read/write split using SQL parser
• Distributed sharding with scatter/gather engine
• Cross-shard transactions with two-phase commit
• Replicated tables for shard-local joins
• Monotonic big integer primary keys
• Sharding key mutation via UPDATE
• Consistent cross-shard DDL
• No application changes required