Re:Clickhouse Local
by lflux on Tuesday March 03, 2020 @04:40PM
(#22478966)
What about Greenplum or CitusDB?
[ Parent
| on HN ]
Re:Clickhouse Local
by atombender on Tuesday March 03, 2020 @05:59PM
(#22479544)
CitusDB is not relevant here, I believe, as it still uses Postgres' table storage, so it's not columnar. It might be good for analytical workloads, but I very much doubt it will perform anywhere close to ClickHouse.
Greenplum: I've not used it, but it does support columnar tables, so maybe it's comparable.
Re:Clickhouse Local
by justinsaccount on Tuesday March 03, 2020 @11:51PM
(#22481297)
Greenplum seems to like a way to throw more hardware at a problem. Queries are too slow with postgres? Shard your data across machines and distribute queries to speed things up by running in parallel. It's using scale as a means to compensate for low efficiency.
On the opposite side of the spectrum you have other open source projects like questDB that have full focus on core performance: constantly optimise to get as much as possible from a single processor core. You can't scale out (at least yet), but given how fast it is on single core, it will be pretty powerful if they chose to go this route.
Re:Clickhouse Local
by atombender on Tuesday March 03, 2020 @05:56PM
(#22479530)
Note that Greenplum supports column-oriented tables. I haven't used it myself, so I can't comment on whether it's slower than ClickHouse.