yandex/odyssey
FreeScalable PostgreSQL connection pooler
FreeFree tier
About yandex/odyssey
Odyssey is an AI-ready, advanced multi-threaded PostgreSQL connection pooler and request router developed by Yandex. It is production‑ready and used in large deployments. Key features include multi‑threaded processing for high SSL/TLS performance, advanced transactional pooling that automatically cancels and rolls back abandoned transactions, flexible pool configuration per database/user, support for md5, clear text, and PAM LDAP authentication, and detailed logging with unique connection identifiers. Odyssey currently runs only on Linux x86/x86_64.
Key Features
Multi-threaded processing for scalable performance
Advanced transactional pooling with automatic cancel and rollback
Pool configuration per database and user with separate limits
Full SSL/TLS support and authentication methods: md5, clear text, PAM LDAP
Logging with unique UUIDs for each client and server connection
Supports systemd notify and Prometheus exporter
Pros & Cons
Pros
- Production‑ready, used in large deployments
- Multi‑threaded design enhances scalability and SSL/TLS performance
- Advanced transactional pooling reduces resource waste
- Flexible and fine‑grained pool configuration
- Supports multiple authentication methods including PAM LDAP
- Detailed logging with unique connection identifiers for debugging
Cons
- Currently supports only Linux on x86/x86_64 architectures
- Requires manual compilation and configuration
- May have a steeper learning curve for simpler use cases
Best For
Scaling PostgreSQL connections in high‑traffic applicationsManaging connection pools in large production environmentsImproving SSL/TLS performance through multi‑threaded architectureProviding transactional pooling with automatic cleanup of rogue connectionsCentralizing authentication and access control for PostgreSQL databases
FAQ
Is Odyssey production-ready?
Yes, Odyssey is production‑ready and is used in large production setups.
What authentication methods does Odyssey support?
Odyssey supports md5, clear text, and PAM LDAP authentication, as well as full SSL/TLS.
What platforms does Odyssey run on?
Odyssey currently runs only on Linux with x86/x86_64 architectures.
How can I build Odyssey?
Odyssey requires cmake >= 3.12.4, gcc >= 4.6, and openssl. Optional dependencies include libsystemd-dev and systemd-devel. Build commands are available in the README.