Odyssey review
A focused, open-source pooler for PostgreSQL session and transaction workloads.
Reviewed by iTechGuides Editors · Editorial team · Updated Nov 2026
Odyssey is a self-hosted connection pooler and request router for PostgreSQL workloads. It is aimed at teams that need session or transaction pooling, connection limits, backend routing, and load balancing while keeping deployment under their control. The project runs on Linux, supports the PostgreSQL wire protocol, and is also identified as supporting Apache Cloudberry. Its multi-threaded design shares server connection pools across processing threads.
Odyssey is distributed as open source under the BSD-3-Clause license, with a free plan. Deployment is standalone and self-hosted, so teams manage installation, configuration, and operations on Linux. Configuration can set pool size and connection-acquisition timeouts, while pool rules are defined separately for each database and user. A pool size of zero disables the limit, allowing operators to choose how capacity is governed. These controls fit environments that need explicit connection policies rather than a managed service.
The product’s strongest depth is in PostgreSQL pooling behavior. Session, transaction, and statement modes are documented; transaction pooling multiplexes client connections over fewer PostgreSQL backends and supports prepared statements. TLS and authentication options include PAM and LDAP, and backend routing adds load-balancing controls. Choose Odyssey when PostgreSQL connection management, routing, and self-hosted control are priorities. Teams seeking a managed deployment, broader database coverage, or AI capabilities should consider alternatives with those characteristics.
Odyssey pros and cons
- Where it wins
- Multiplexes client connections through session and transaction pooling
- Per-database and per-user pool rules with configurable limits
- TLS, PAM, LDAP, backend routing, and load balancing options
- Where it doesn't
- Self-hosted Linux deployment puts operations on your team
- Database support centers on PostgreSQL and Apache Cloudberry
- No AI features are provided
Odyssey fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update