Cost optimization · data infrastructure
ClickHouse cost optimization
77.8% cost reduction (6× more efficient). Migrated customer segmentation from BigQuery Views to ClickHouse using batched deterministic hashing (cityHash64) and right-sized compute (64GB → 16GB RAM). The workload was wrong for the database model, not a tuning problem.
₹1.4 lakhs/month savings · 6× efficiency gain