Tag
This article explains the problem of poisoned connection pools in PostgreSQL when using PgBouncer, where stale session state can cause write errors, and provides a solution using DISCARD ALL to reset connections.
A developer reflects on a decade-old article about Postgres connection management, surveys popular managed Postgres providers, and argues that PgBouncer-style connection pooling is effectively a mandatory core feature.
ClickHouse Managed Postgres scales PgBouncer to 4x throughput by running a fleet of processes with SO_REUSEPORT, enabling multi-core utilization and solving cancellation forwarding via peering.
PgDog is a tool that allows you to scale PostgreSQL without modifying your application, providing connection pooling and load balancing.
PgDog is a new Postgres connection pooler that preserves application code by handling SET statements and LISTEN/NOTIFY, unlike existing poolers that require trade-offs.
A detailed technical guide explaining how PgBouncer works as a PostgreSQL connection pooler, covering its pooling modes, production deployment, and common pitfalls.
A developer shares lessons learned while optimizing Elixir applications, particularly focusing on performance improvements to a Postgres connection pooler (Ultravisor). The article covers profiling techniques using flame graphs, call tracing, and tools like eFlambè and tprof.