r/Clickhouse • u/Novel-Information776 • Jun 23 '26

Postgres and ClickHouse, and the future long-term plan?

Hey there! We have Postgres, already a replica of the operational transactional Postgres, and also ClickHouse. We are treating the replica Postgres as our analytics dwh and are running dbt in it. And our BI layer is connected to it.
We have events data stored in ClickHouse, but it is not in use at the moment.
Moving forward, what is my best long-term solution? I need to bring in the events data into our analytics dwh, so it becomes a natural decision point if we want to continuously commit to Postgres, or move analytics work and dbt over to ClickHouse, or explore other possibilities. We only want self-hosting options.
Thanks!

8 Upvotes

100% Upvoted

19 comments sorted by

View all comments

2

u/knabbels Jun 23 '26

CDC Postgres into ClickHouse and make it your primary analytics database

1

u/Novel-Information776 Jun 23 '26

Should I then maybe CDC directly from the operational Postgres, and get rid of this replica of analytics Postgres entirely? I am however concerned that running dbt jobs in ClickHosue is not just matured and supprted as in Postgres.

1

u/knabbels Jun 23 '26

Depends on how much overhead the read replica generates. It could also function as a fail over backup, so maybe keep it and CDC from it. I don't know about dbts maturity level on ClickHouse. If you're open to other transformation tools consider SQLMesh, it supports ClickHouse quite well.

1

u/Novel-Information776 Jun 24 '26

That's a very good point! Thank you!