Handling Retries, Duplicates, and Data Loss in ClickHouse
Learn how ClickHouse INSERT retries cause duplicate rows or data loss. Explore deduplication and quorum settings to improve insert reliability.
November 3, 20268 min read
Tag: performance optimization
Posts tagged "performance optimization"
Lightweight UPDATE in ClickHouse®: When and How to Use It
Learn how lightweight UPDATE works in ClickHouse®, how patch parts improve performance, and when to use it over traditional mutations.
August 19, 20269 min read
Debugging Query Performance with Per-Second Metrics
Debug query performance with per-second metrics to identify memory spikes, disk I/O, cache misses, CPU bottlenecks, JOIN issues, and query spills.
August 18, 202614 min read
ClickHouse® 26.3 LTS: What's New and Why Upgrade?
Explore the major features and upgrade considerations in ClickHouse® 26.3 LTS. Learn why this Long-Term Support release is good choice for production workloads.
July 15, 20268 min read
ClickHouse® vs PostgreSQL: When to Use Which?
ClickHouse® vs PostgreSQL - what's the real difference? Learn how each database works, when to use which, and its performance trade-offs.
June 4, 20268 min read
Lightweight Delete in ClickHouse®
Learn how Lightweight DELETE works in ClickHouse®, including its internal masking mechanism, background merges, performance trade-offs, limitations, and when to
February 28, 20264 min read