ClickHouse vs Postgres on a single server benchmark

[Edward]

Hi guys, thanks for this wonderful project. It looks amazing.

I'm currently using postgres, and have plans to try ClickHouse for my datasets.

It would be amazing if you could add Postgres comparison (with and without citus columnar storage) to the benchmark page.

Thanks,

Ed

[Itai Shirav]

I haven't made a rigorous comparison, but I did convert a time-series table with 9 million rows from Postgres to ClickHouse. 

Under ClickHouse queries run about 100 times faster, and the table takes 20 times less disk space. Which is pretty amazing if you ask me.