Sign in to confirm you’re not a bot
This helps protect our community. Learn more

What I learned benchmarking Citus & Postgres performance with HammerDB | Citus Con 2023

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2K views 1 year ago #PostgreSQL #CitusCon #Citus
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: 1. Choosing the Citus database cluster to test: size and tuning of each node 2. Configuring HammerDB based on the cluster's capacity, in order to utilize the cluster's resources as much as possible 3. Interpreting the benchmark result 4.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 & decluttering, algebraic objects, and foreign languages. ► Video bookmarks: ⏩ 00:00 Introducing Naisila ⏩ 01:27 Naisila’s benchmarking talk begins here ⏩ 04:00 …...more
...more
What I learned benchmarking Citus & Postgres performance with HammerDB | Citus Con 2023
47Likes
2,084Views
2023May 8
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: 1. Choosing the Citus database cluster to test: size and tuning of each node 2. Configuring HammerDB based on the cluster's capacity, in order to utilize the cluster's resources as much as possible 3. Interpreting the benchmark result 4.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 & decluttering, algebraic objects, and foreign languages. ► Video bookmarks: ⏩ 00:00 Introducing Naisila ⏩ 01:27 Naisila’s benchmarking talk begins here ⏩ 04:00 OLTP and Citus ⏩ 04:58 HammerDB TPROC-C ⏩ 06:28 Running benchmarks on Azure Cosmos DB for PostgreSQL ⏩ 09:48 Interpreting benchmark results ⏩ 13:30 Increasing concurrent connections ⏩ 19:21 Adjusting the shard count ⏩ 26:20 What I learned about benchmarking ⏩ 28:13 Q&A ✅ Learn more: Watch more Citus Con talks: https://aka.ms/cituscon-playlist 📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon 📌 Let’s connect:   Twitter – @CitusCon,   / cituscon   ⭐ Stay connected with the Citus open source project on GitHub: https://github.com/citusdata/citus 💡Take the Azure Cosmos DB for PostgreSQL training at https://aka.ms/pg-azurecosmosdb-training 🔔 Subscribe to the Citus monthly technical newsletter: https://aka.ms/citus-newsletter More resources: 📣 Slides for this talk: https://github.com/naisila/slides/blo... #CitusCon #PostgreSQL #Citus

Follow along using the transcript.

Microsoft Developer

588K subscribers