Unlock this content
Enter your email to unlock this content for free
Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.
ClickHouse® Engines Deep Dive
This module covers ClickHouse table engines: how data is stored, indexed, merged, and queried.
What you'll learn
- Engine Architecture: How engines define data storage, indexing, and merge behavior
- MergeTree Family: Understanding the most important engine family for production use
- Partitioning & Sorting: How to choose partition keys and sorting keys for optimal performance
- Pre-aggregation: When and how to use SummingMergeTree and AggregatingMergeTree
- Engine Selection: Quick reference for choosing the right engine for your use case
Learn More
- Engines - Complete engines reference
- MergeTree Engine - MergeTree documentation