logoalt Hacker News

zX41ZdbW11/08/20240 repliesview on HN

You can store all data in ClickHouse (on S3 or on local storage); there is no need to separate historical and real-time data.

To insert data into ClickHouse, you use the INSERT query to insert data as frequently as you'd like.

Alternatively, you can set up continuous replication from Postgres to ClickHouse, which is available in ClickHouse Cloud.