On: Show HN: BemiDB – Postgres read replica optimized ...

[zX41ZdbW]

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.