Open Electricity: Lessons learned migrating from Postgres and TimescaleDB to ClickHouse

Nik Cubrliovic, Software Developer & Data Engineer at nineprimes

This talk was delivered live at the ClickHouse Melbourne meetup on 24 February at State of Grace, by Nik Cubrliovic, Software Developer & Data Engineer @ nineprimes.

The full agenda can be found at https://www.meetup.com/clickhouse-mel...

Talk Title: Open Electricity: Lessons learned migrating from Postgres and TimescaleDB to ClickHouse

Talk Description: As energy data grows in volume and velocity, traditional relational and time-series systems can start to show their limits. In this talk delivered lived at the ClickHouse Melbourne meetup, Nik shared their journey migrating Open Electricity from Postgres and TimescaleDB to ClickHouse. We’ll cover the technical challenges they faced, key architectural decisions, performance benchmarks, cost considerations, and the unexpected lessons learned along the way.

Slides can be accessed from https://github.com/ClickHouse/clickhouse-presentations/blob/master/2026-meetup-melbourne-1/Talk%202%20-%20Melbourne%20Meetup%20-%20Open%20Electricity.pdf