HNHacker News
TopNewBestAskShowJobs

tinybit_ch

1 karma · joined March 4, 2024

submissionscomments
tinybit_ch··on Show HN: Postgres Columnstore index vs. ClickHouse for OLAP queries
What's puzzling is ingesting and indexing speed. That part of the test set was 60 times slower than clickhouse. So, whatever Clickhouse takes a day to ingest, Tablespace will take 2 months. Also, massive 13x overhead for storage makes things look even stranger.

All of the above + your benchmark results https://tinyurl.com/4yz87ur4 show that you did trade off visibly improving 9 queries out of 43 at massive expense of disk space and ingest speed. Okay, I guess, maybe there's a usecase for that. But I would not call it a 1.6x speedup over Clickhouse, this is purely misleading.