Webinar Slides. MORE secrets of ClickHouse Query Performance

By Robert Hodges on May 27th, 2020

Webinar Slides. MORE secrets of ClickHouse Query Performance

Robert Hodges ClickHouseClusterswebinar

By Robert Hodges and Alexander Zaitsev
Slides for the Webinar, presented on May 27, 2020
Webinar recording is available here

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Sign up now to polish your ClickHouse performance skills!

Leave a Reply

More Presentations

Webinar Slides. Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

By Adam Brown and Robert Hodges Slides for the Webinar, presented on June 23, 2020 Webinar recording is available here Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We'll start with an overview of the Mux platform and the importance of real-time feedback. We'll then discuss key features of ClickHouse that enable it to ingest live session data and provide real-time dashboards to Mux users. Finally, we'll talk a bit about the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.