Posts about tech
PostgreSQL Connection Pooler Benchmark
Hi everyone, I’ve tested 3 different connection poolers from community projects. Pgbouncer Odyssey Pgcat Before I dive into test setup and test results, here is a quick rundown of their pros and cons. Pgbouncer Pros Cons It has a proven track record Single threaded Used and well known in the team Need to start new pgbouncer instance from different ports if you want to scale Pgcat Pros Cons Multi threaded New project Load balancing Beta version Query routing Lacks authentication method support Odyssey Pros Cons Used by Yandex and their cloud service by default Documentation is sometimes hard to navigate Multi threaded Can give database and user specific pool settings Test setup...