Topic

Database read replicas

Copies of a primary database kept in sync from its write stream and used to serve read traffic, adding read capacity and redundancy without changing how data is stored.

Current clusters

build1 publisher

A read replica moves the dashboard load onto the same 8 KB row-store pages

ClickHouse's own guide says Postgres replicas inherit the primary's row-oriented limits, and MotherDuck models a 50ms dashboard aggregation growing to five seconds at tens of millions of rows before it times out.

Publishers:dev.to

Reality

Evidence34
Adoption: Insufficient
Hype gap+33
Incentives63
Confidence41