PGKeeper: Building the bouncer we needed for Postgres

Figma built PGKeeper, a Go-based PostgreSQL connection pooler and load management service replacing PgBouncer.

• •PgBouncer's single-threaded architecture lacked vertical scalability and sophisticated load management like CoDel and admission control
• •PGKeeper uses gRPC interface with query metadata (traffic tier, user type) for intelligent handling decisions
• •Built on PGX PostgreSQL toolkit and deployed behind NLB with multiple replicas per database instance
• •Implements admission control, connection pool management with rate limiting, and query execution
• •Features include pool warming, rate-limited connection creation/destruction, bounded exhaust, and auto rollback

This summary was automatically generated by AI based on the original article and may not be fully accurate.