KJKiruthiga Jaiganeshinclickhouse-partition-swap-trick.hashnode.dev¡Jul 29, 2025 ¡ 2 min readâĄď¸ Fast Replacing of Millions of Rows Daily in ClickHouse â A Partitioned Merge Tree Solutionđ¨ The Challenge:We had to replace millions of rows daily, covering data from the past 60 days, and run aggregations on top. Initially, we explored: â AggregatingMergeTree: Worked well only with incremental data, but not suited for full data replace...00