tubeshowcase●1,661,801 videos♡ My collection 0
← Learn to Code

Learn to Code31:33

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

Microsoft Developer ↗

From the creator

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, https://twitter.com/C

Published 2023-05-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code