Episode
What I learned benchmarking Citus & Postgres performance with HammerDB | Citus Con 2023
with Naisila Puka
Video recording of Naisila Puka’s conference talk at Citus Con: An Event for Postgres 2023—about measuring database performance of Azure Cosmos DB for PostgreSQL, the new home for Citus on Azure, by using the HammerDB benchmark.
In this talk you’ll get a tour of what Naisila learned in the whole benchmarking process, including:
- Choosing the Citus database cluster to test: size and tuning of each node
- Configuring HammerDB based on the cluster's capacity, in order to utilize the cluster's resources as much as possible
- Interpreting the benchmark result
- Tweaking parameters in steps 1 and 2 based on the CPU and Disk utilization graphs
Naisila Puka is a software engineer working on the Citus database engine in the Postgres team at Microsoft. She is a fan of organizing & de-cluttering, algebraic objects, and foreign languages.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
Video recording of Naisila Puka’s conference talk at Citus Con: An Event for Postgres 2023—about measuring database performance of Azure Cosmos DB for PostgreSQL, the new home for Citus on Azure, by using the HammerDB benchmark.
In this talk you’ll get a tour of what Naisila learned in the whole benchmarking process, including:
- Choosing the Citus database cluster to test: size and tuning of each node
- Configuring HammerDB based on the cluster's capacity, in order to utilize the cluster's resources as much as possible
- Interpreting the benchmark result
- Tweaking parameters in steps 1 and 2 based on the CPU and Disk utilization graphs
Naisila Puka is a software engineer working on the Citus database engine in the Postgres team at Microsoft. She is a fan of organizing & de-cluttering, algebraic objects, and foreign languages.
Recommended resources
- Watch more Citus Con 2023 talks
- Everything you need to know about Citus Con: An Event for Postgres 2023
- Star the GitHub repo for the Citus database extension, to show your support of Citus open source
Connect
- Citus Con An Event for Postgres | Twitter: @CitusCon
Have feedback? Submit an issue here.