Skip navigation

Speaker:

Lotte Felius

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

(Livestream 2)

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

The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).