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.
