POSETTE 2024 is a wrap! Missed it? Watch all 42 talks
Speaker:
Lotte Felius
PhD Student in the Database Architectures group at CWI
Currently, I am a second year PhD student at the “Centrum voor Wiskunde & Informatica” (CWI), based in Amsterdam, Netherlands. I’m in the Database Architectures group and my current research includes secure query processing, lightweight compression on GPUs and secure next-gen file formats. Former intern at Citus (Microsoft).
POSETTE 2024 Talk
Lessons Learned from benchmarking and profiling distributed PostgreSQL
In this talk, I’ll explain how I investigated the performance of Citus using the Citus Benchmark Suite and YCSB. Quantifying performance however is not straightforward since Citus is a distributed system where queries are distributed across multiple worker nodes. Therefore, I’ll explain some of my learnings as a former intern with no prior experience in benchmarking Databases, which includes:
- The pros and cons of different architectures used for distributed database systems based on PostgreSQL
- Why quantifying performance is harder for distributed database systems and how you can use benchmarks to get an accurate indication of the performance
- How to identify bottlenecks based on benchmarking results and which optimizations you can possibly to do mitigate them
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.