MergeTree table engine family

CollapsingMergeTree vs ReplacingMergeTree

CollapsingMergeTree vs ReplacingMergeTree.

Part names & MVCC

Part names & multiversion concurrency control.

How to pick an ORDER BY / PRIMARY KEY / PARTITION BY for the MergeTree family table

Optimizing ClickHouse® MergeTree tables

AggregatingMergeTree

index & column files

Merge performance and OPTIMIZE FINAL

Merge performance and OPTIMIZE FINAL DEDUPLICATE BY expr

Nulls in order by

ReplacingMergeTree

Skip index

SummingMergeTree

UPSERT by VersionedCollapsingMergeTree

How to aggregate mutating event stream with duplicates