News for hackers. Stuff that matters.

A comment on ClickHouse, Inc.. Parent comment

Re:ClickHouse, Inc. by stavros on Monday September 20, 2021 @06:36PM (#28599935)
I have a related question, in case anyone knows: We want to store typical analytics data somewhere (currently in BigQuery) to analyze with Looker. Things like "CI run started", "CI run finished" and then calculate analytics over average CI runtimes.

Which database would be a good fit for this? There isn't too much data, maybe tens of thousands of rows eventually. Would Timescale be a good fit? I'd prefer that, due to existing familiarity with Postgres, but if ClickHouse is better, that's good too.

[ Parent | on HN ]
Re:ClickHouse, Inc. by ants_a on Monday September 20, 2021 @08:58PM (#28600917)
Postgres has much more featureful query language, and at tens of thousands of rows the performance difference is irrelevant. The story becomes different when answering a query has to touch millions of records and the answer is needed in milliseconds.
[ Parent | on HN ]
Re:ClickHouse, Inc. by stavros on Tuesday September 21, 2021 @02:16AM (#28602448)
Thanks!
[ Parent | on HN ]
Re:ClickHouse, Inc. by saadatq on Monday September 20, 2021 @09:30PM (#28601122)
Why move off BigQuery?
[ Parent | on HN ]
Re:ClickHouse, Inc. by stavros on Tuesday September 21, 2021 @02:16AM (#28602453)
If BigQuery is good, there's no reason to. I just assumed a time-series database would be better suited to the workload.
[ Parent | on HN ]