News for hackers. Stuff that matters.
Re:ClickHouse cost-efficiency in action: analyzing 500B rows... by brobinson on Monday January 06, 2020 @02:16PM (#21972129)
Yeah, this post could have been titled "Why Materialized Views are Awesome"
Re:ClickHouse cost-efficiency in action: analyzing 500B rows... by bdcravens on Monday January 06, 2020 @05:15PM (#21974068)
Clickhouse is also crazy fast without materialized views - I've only done some PoC's against it, but in loading a largish data set of raw invoice CSVs, I was very impressed with the performance compared to our standard RDBMS.
Re:ClickHouse cost-efficiency in action: analyzing 500B rows... by tumanian on Tuesday January 07, 2020 @12:30AM (#21977203)
that sounds like a non-canonical use of clickhouse. Wouldnt a good RDBMS be a better fit for invoice data? This is on the surface, of course, really interested in what is this invoice data like, and what queries are you trying to run on them.