Home / Companies / Yugabyte / Blog / Post Details
Content Deep Dive

Built-in Connection Manager Turns Key  PostgreSQL Weakness into a Strength

Blog post from Yugabyte

Post Details
Company
Date Published
Author
Michael Haag
Word Count
1,041
Language
English
Hacker News Points
-
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.