ClickHouse's async insert mode is one of those features that sounds simple but has real depth: internal buffering, configurable flush thresholds, deduplication edge cases. We wrote a technical breakdown of how it works and the tradeoffs involved.

Relevant if you're building anything that writes to ClickHouse at large volume: