Company
Date Published
Author
Michael Haag
Word count
1041
Language
English
Hacker News points
None

Summary

YugabyteDB's new built-in Connection Manager in version 2.19.2 improves performance and simplifies application architecture by enabling up to 20x faster connection creation times and increasing the number of supported connections up to 5x, while maintaining a constant throughput. This addresses a well-known PostgreSQL weakness, turning it into a strength. The new Connection Manager uses logical connections to guarantee consistent database connectivity for applications and supports SQL features such as TEMP TABLE, WITH HOLD CURSORS, and more, with no limitations compared to other pooling solutions running in transaction mode. It also supports session parameters and prepared statements, overcoming some SQL limitations. YugabyteDB's Connection Manager has been modified from the open source connection pooler Odyssey and is available for technical preview in 2.19.