POSETTE starts Jun 11th! Save the date
Speaker:
Boriss Mejias
PostgreSQL Solution Architect EDB
I'm a holistic system software engineer, PostgreSQL solution architect at EDB, free software user, and headbanger. I got my PhD researching distributed self-managing systems and I have been working with PostgreSQL since version 9.1. In 2018 I started the PostgreSQL User Group in Belgium. I have presented in many conferences in academia, open source, and Postgres. Being a father of two fantastic daughters, I also have experience in storytelling. Now that they have grown up, I have decided to try telling stories to the Postgres community.
POSETTE 2024 Talk
Postgres Storytelling: What’s going on with Synchronous Replication?
This is an illustrated Postgres story about Monica DeBea, a fictional talented support engineer based on real-life talented support engineers. Once upon a time Monica got a phone call at her desk at the end of the working day. She anticipated it was David again with a problem that would keep her at the office until the darkest hour. But it wasn’t David, it was Derk, the software engineer that is always walking around with a chess board, and he had a very interesting problem to discuss. Synchronous replication was extremely slow, and the only observable symptom was a huge amount of ‘SyncRep’ wait events. The network was not to be blamed, the CPU usage was smooth, and the RAM had enough space to still allocate the latest release of “Thundermother” in high resolution. So what was going on? This was a nice challenge.
In this Postgres “storytelling” talk about Monica DeBea, you will learn how synchronous replication works, how vacuum and large tables affect replication, and what you need to take into account with respect to WAL files.
Past Talks
Postgres Storytelling: Support in the Darkest Hour (Citus Con 2023)
- Video: Watch the talk on YouTube
Podcast Appearances
Why give talks at Postgres conferences with Álvaro Herrera & Boriss Mejías
- 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).
Citus Data is now part of 
©2024 Citus Data, a Microsoft Company. All rights reserved.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.