Why we built yet another Postgres connection pooler
4 hours ago
- #Connection Pooling
- #Postgres
- #Database Scaling
- PgDog is a Postgres proxy designed to scale databases by handling connection pooling more effectively.
- Unlike other poolers such as PgBouncer, it allows clients to keep using SET commands and LISTEN/NOTIFY without requiring code changes.
- It uses a built-in SQL parser to manage connection state and supports multithreading via Tokio for better performance and handling of traffic bursts.
- The tool has been in production for over a year, is open source, and aims to eliminate trade-offs associated with traditional poolers.