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

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 17 Jun, 12:06 UTC

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.

Sources

• T192x faster queries: How Open Electricity uses ClickHouse to track Australia’s energy transition in real timeDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale17 Jun, 12:06