92x faster queries: How Open Electricity uses ClickHouse to track Australia’s energy transition in real time (opens in new tab)

Open Electricity migrated ~1 billion rows of Australian energy data from Postgres and TimescaleDB to ClickHouse, achieving 92x faster queries on a fraction of the hardware.