POSETTE 2024 is a wrap! Missed it? Watch all 42 talks
Speaker:
Jelte Fennema-Nio
Principal Engineer at Microsoft
Currently I'm working on Citus, Postgres and Pgbouncer at Microsoft. Before that I was a big time Postgres user at Stream, where I worked on low latency APIs for chat and social timelines. I'm one of the current maintainers of the PgBouncer project. I studied at the University of Amsterdam where I got my BSc in Computer Science and MSc in System and Network Engineering.
POSETTE 2024 Talk
Comparing Postgres connection pooler support for prepared statements
Connection poolers have always been very important to achieve good performance in transactional workloads with Postgres. Sadly, for a long time this meant that you couldn't use prepared statements to reduce Postgres query planning overhead. But recently that has changed because prepared statements are now supported by PgBouncer, Odyssey, pgcat, and Supavisor.
In this talk you'll learn about the differences in prepared statement design, performance, and support between these connection poolers.
If you're interested in the answers to one of the following questions, then this is the talk for you:
- How a connection pooler can be useful when you are using Postgres?
- Which connection pooler to choose?
- Technical details about why Postgres prepared statements are so difficult for connection poolers
Past Talks
Postgres without SQL: Natural language queries using GPT-3 & Rust (Citus Con 2023)
- Video: Watch the talk on YouTube
- Slide deck: View the slides on SpeakerDeck
Podcast Appearances
My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot
- Podcast episode: Listen on Transistor.fm
Subscribe to notifications to keep up with POSETTE news
Join the conversation
Use the hashtag #PosetteConf
The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).