from Hacker News

No, QuestDB is not Faster than ClickHouse

by krnaveen14 on 6/16/22, 4:21 PM with 63 comments

  • by PeterZaitsev on 6/16/22, 6:21 PM

    This response illustrates important point - if you're expert in technology A and compare it to technology B, you're not expert in, comparison is very likely to be unfair.

    I very much would like to see vendors at least to follow Journalist ethics and reach out to their competition for optimization comments and suggestions before publishing it, so others are given a chance to suggest optimizations

  • by bluestreak on 6/16/22, 6:29 PM

    Our article in question can be found here: https://questdb.io/blog/2022/05/26/query-benchmark-questdb-v...

    The intent of the article was to showcase JIT-optimised WHERE clause and we did not use any indexes on QuestDB.

  • by gauravphoenix on 6/16/22, 7:07 PM

    I have always felt that DB benchmarks are useless, always use your own dataset

    https://gauravkumar.blog/performance-benchmarks-are-useless....

  • by thegeomaster on 6/16/22, 5:52 PM

    Sounds like they didn't re-do the QuestDB benchmark with same change to the indexes, and so their claim is that Clickhouse is 27x faster with a specific index than QuestDB without that index. Which is not a fair comparison.

    Also, the tone of the post sounds really arrogant. They try to hide it a bit, I feel, but it just seeps through.

  • by noxvilleza on 6/16/22, 6:28 PM

    Is there an existing named adage for something like "if one creates a benchmark in order to rank general performance of some products, some of those products will ultimately sacrifice general performance in order to optimize for that benchmark"?

  • by gigawatts on 6/17/22, 6:57 PM

    I have a ton of respect for the clickhouse team. We ran a massive cluster storing trillions of events across thousands of servers for years to serve a real-time reporting/ api use case and the tech is blazing fast and never once let us down.

  • by intellix on 6/17/22, 5:10 AM

    everytime I see the name Clickhouse I think I'm reading about a CRM tool. It's the worst name for a database ever.