Open sourcing Odyssey: scalable connection pooler

Hi all.

Yandex team is proud to announce the first open source version of Odyssey, a new multi-threaded connection pooler for PostgreSQL designed for high load databases with many CPU cores.

It allows us to handle workloads with 10k+ TLS connections and 100k+ TPS per server with much fewer opened connections to PostgreSQL than several pgbouncers.

Main features are:
1. Linear scaling with number of CPU cores.
2. Different pooling modes with ability to configure authentication, pooling mode, limits and more per pool.
3. Ability to automatically rollback transactions and cancel postgres backends on client disconnections.
4. Accurate PostgreSQL error forwarding.

Odyssey is written in C, the code is distributed under BSD license and can be found on github [1]. It has asynchonous multi-threaded architecture which is driven by coroutine engine. One of the main goals was to make code base friendly for new developers and easily extensible for future development.

Although we run Odyssey in production, the project is currently in beta. We appreciate any kind of feedback and contribution to the project.

[1] https://github.com/yandex/odyssey <https://github.com/yandex/odyssey>

Thank you!

--
May the force be with you…
https://simply.name