Overview
Explore the latest advancements in PostgreSQL connection pooling with this conference talk from Citus Con: An Event for Postgres 2022. Delve into Andrey Borodin's presentation on Odyssey 1.3, an advanced multi-threaded connection pooler and request router for PostgreSQL. Learn about new features such as standby lag polling and transaction pooling for prepared statements. Discover the challenges faced during development, limitations of these features, and the workloads they enable. Gain insights from Andrey Borodin, an experienced Postgres contributor and Associate Professor at Yandex School for Data Analysis and Ural Federal University. Follow along with video bookmarks covering transaction connection pooling overview, Odyssey version details, standby log polling, prepared statement pooling, and future development plans. Engage with the Q&A session to deepen your understanding of Odyssey and its potential applications in PostgreSQL environments.
Syllabus
Introduction.
Transaction connection pooling overview.
Odyssey version details.
Standby log polling.
Prepared statement pooling.
Try Odyssey 1.3.
What would you like to see in Odyssey 1.4?.
Q&A with Andrey & Aaron.
Taught by
Microsoft Developer