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
Tag: performance optimization
Posts tagged "performance optimization"
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