How CockroachDB’s GEO‑Partitioning Solves Hot‑Cold Data Separation at Scale

This article explains CockroachDB’s partitioning features—especially GEO‑Partitioning—detailing its evolution, implementation principles, advantages over traditional databases, and a step‑by‑step hot‑cold data separation use case with multi‑region deployment, configuration commands, performance considerations, and Q&A.

CockroachDBGEO-PartitioningHot/Cold Data

0 likes · 19 min read

How CockroachDB’s GEO‑Partitioning Solves Hot‑Cold Data Separation at Scale

Big Data Technology Architecture

May 29, 2019 · Backend Development

Elasticsearch Performance Optimization for Billion‑Scale Data

The article explains how to improve Elasticsearch query speed on tens of billions of records by leveraging filesystem cache, limiting indexed fields, using hot‑cold data separation, designing efficient document models, and employing scroll or search_after APIs to avoid deep pagination bottlenecks.

BackendFilesystem CacheHot/Cold Data

0 likes · 11 min read

Elasticsearch Performance Optimization for Billion‑Scale Data