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.

  • Show HN is for things you've made people can try, take a look at https://news.ycombinator.com/showhn.html.

    You can post this as a regular post, without the 'Show HN'.

  • Are you guy comparing 16vCPU/32GB vs 8vCPU/32GB and say yours is only 1.6 faster?