Sanjeev Singh·Aug 22From Heap to Columnar to Lucene to PAXWhy PostgreSQL, ClickHouse, CrateDB, and CedarDB make very different storage choices
Sanjeev Singh·Dec 26, 2025Measuring Late Materialization Impact: PostgreSQL vs ClickHouseAs data volumes scale from millions to tens of millions of rows, analytical queries on PostgreSQL often hit a performance wall — even…
Sanjeev Singh·Dec 24, 2025When PostgreSQL Meets OLAP: Benchmarking the New Generation of Analytical DatabasesFor DBREs, SREs, and Solution Architects Evaluating Analytical Workloads
Sanjeev Singh·Nov 25, 2025ClickHouse Performance: How I Got 18x Faster Queries and 11% Storage Savings with ORDER BYHow Column Ordering Can Deliver 18x Query Speedup and 11% Storage Savings
Sanjeev Singh·Sep 21, 202510x Write Amplification: PostgreSQL vs MySQL Index Architecture AnalysisUber’s engineering team documented write amplification as a key factor in their PostgreSQL to MySQL migration decision. Inspired by their…
Sanjeev Singh·Jul 6, 2025The Day Our ClickHouse Cluster Went Silent: A Production Crisis PostmortemHow detached parts triggered a cascading failure and what we learned from it
Sanjeev Singh·Jul 6, 2025Understanding Detached Parts in ClickHouse: A Deep DiveA comprehensive guide to one of ClickHouse’s most important yet overlooked concepts
Sanjeev Singh·Jul 5, 2025The 5-Step System to Optimize Slow PostgreSQL QueriesA battle-tested approach to debugging and optimizing PostgreSQL performance that will transform your database from sluggish to…
Sanjeev Singh·Jul 5, 2025The Multi-Region CockroachDB Performance PlaybookWhy Some Queries Fly and Others Crawl — A Production DBRE’s GuideA response icon1A response icon1
Sanjeev Singh·Jun 30, 2025Can OrioleDB Solve PostgreSQL’s Biggest Operational Headache?If you’ve run PostgreSQL in production with heavy write workloads, you’ve felt the pain: table bloat that creeps up on you, then hits like…