Why we built yet another Postgres connection pooler
Summary
PgDog introduces a new Postgres connection pooler that aims to avoid leaky abstractions by preserving session state and Postgres features like SET and LISTEN/NOTIFY. It describes a built-in SQL parser for per-connection state, a multithreaded Tokio-based runtime for scalability, and how it compares to existing poolers such as PgBouncer and RDS Proxy. The piece also covers deployment considerations, performance implications, and its open-source nature.