Blog

ClickHouse Array Storage: The Explosion Technique

Discover how ClickHouse efficiently stores arrays using values + offsets columns, enabling blazing-fast analytical queries and optimal compression.

September 7, 2025

clickhouse database arrays storage performance analytics

Prometheus Internals: The Clever Compression Behind Time Series Storage

Dive deep into how Prometheus uses delta and XOR compression to efficiently store millions of time series metrics, inspired by Facebook's Gorilla paper.

September 6, 2025

prometheus monitoring compression time-series observability

PostgreSQL XID Wraparound: A Critical Infrastructure Crisis Averted

Learn about PostgreSQL's transaction ID wraparound issue, how it nearly caused a database outage, and the steps taken to prevent it from happening again.

August 8, 2025

postgresql database infrastructure rds vacuum monitoring