News for hackers. Stuff that matters.
Re:Comparing ClickHouse to PostgreSQL and TimescaleDB for ti... by ryanbooz on Thursday October 21, 2021 @11:58AM (#28946405)
(N.B. post author)

Thanks for the feedback. Without knowing your situation, one of the things we show in the blog post is that TimescaleDB compression often changes the game on those kinds of queries (data is transformed to columnar storage when you compress). You don't mention if you did that or not, but it's something we've seen/noticed in every other benchmark at this point - that folks don't enable it for the benchmark.

And second point of the article is that you have lots of options for whatever works in your specific situation. But, make sure you're using the chosen database features before counting it out. :-)

Re:Comparing ClickHouse to PostgreSQL and TimescaleDB for ti... by maxmcd on Thursday October 21, 2021 @01:34PM (#28947990)
I wonder if it's worth taking a page out of the MongoDB book and enabling these kinds of benchmark altering settings by default. We certainly selected clickhouse over tailscale internally because of major performance differences in our internal testing that might have gone the other way had we "known better".
Re:Comparing ClickHouse to PostgreSQL and TimescaleDB for ti... by ryanbooz on Thursday October 21, 2021 @01:37PM (#28948057)
Indeed. Lots of discussion over this in the last few months. There are nuances, but I think you'll see some progress in this area over the next year.