pgdog is a PostgreSQL sharding proxy, distributed SQL router, and connection pooler. It is designed to enable horizontal data distribution by splitting tables and indices across multiple independent servers to scale storage and processing capacity.
The project distinguishes itself through online resharding capabilities, using logical replication to move data between shards without application downtime. It supports multiple routing strategies, including hash, list, and range-based query routing, and manages distributed atomic transactions using a two-phase commit process to ensure consistency across shards.
The system also covers high availability and traffic management, providing read-write splitting to balance queries between primary and replica nodes. It includes multiplexed connection pooling, real-time health monitoring with OpenTelemetry integration, and a plugin architecture for extending routing logic via shared libraries.
The software can be deployed as a containerized service on AWS ECS or via Kubernetes deployment charts.
