Ok, I'm Officially Impressed With ClickHouse
Greg Beam <ki7mt01@...>
I was going through their examples (on my local workstation), testing things out, and getting a feel the CLI / API. I decided to load one of their bigger datasets and play around some. I chose the Airline OnTime-Dataset first and went through all the example queries. This thing is seriously fast, and that's putting it mildly.
I don't know what it would do, or how it would handle, hundreds of concurrent users, but, if it scales with clustering the way it's performing on a single node, it's hard to imagine using anything else (at the price point it offers) with the anticipated volumes WSPR is expecting over the next cycle.
I realize there is still a fair bit of ETL needed before shoving things a into the warehouse, but, I can see use cases of all sorts with this thing.