PgConf.Russia 2017 talks

Connection pooling at any scale

Vladimir Borodin
Yandex, DBA

Vladimir is a system administrator in the department of data storage systems of Yandex which he joined in 2012. He works with everything related to the data storage, mainly with metadata storage recently.

It's not a secret that PostgreSQL connections are expensive so you should save them. To solve this problem there are PgPool-II and PgBouncer for quite a long time. At Yandex tens of thousands of connections to a single database is not a surprise so we use pgbouncer since time immemorial. This talk gives an overview of problems we faced and ways to solve them.