• Nicolas Hourcard

    Nicolas Hourcard

    2 months ago
    Hi folks, we just posted a new blog post where we benchmark queries with questdb vs other databases, upvotes are appreciated if you enjoy the content! https://www.reddit.com/r/programming/ 4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale
  • Alan Kwan

    Alan Kwan

    2 months ago
    The questDB benchmark looks really impressive, but it is not great for my use case still becuase my database is 150-200TB uncompressed. (1) does QuestDB gain over Clickhouse by not compressing, and (2) does QuestDB ever plan to?
  • Nicolas Hourcard

    Nicolas Hourcard

    2 months ago
    thanks - we will add compression later this year. This is likely to be a closed source feature that will be part of QuestDB Cloud as a FYI
  • Alan Kwan

    Alan Kwan

    2 months ago
    I see. Does that mean we can’t deploy via Docker? If not, I wouldn’t recommned this to my students in that case. I recommended it to my students interested in high frequency but unless they have a great machine its not that useful. I would have to recommend Clickhouse + Starrocks
  • Nicolas Hourcard

    Nicolas Hourcard

    2 months ago
    Hey Alan - as we do not have compression currently I would suggest to explore the use case with the eng team whether it is a must or if there are work arounds that could end up working well for you. I will keep you posted with respect to the feature progress in the meanwhile. there could also be special tiers for academia that we will have in place by then, we will explore this further
  • Alan Kwan

    Alan Kwan

    2 months ago
    I see - so you would suggest me sending an email or something? My basic feedback is that without compression, I don’t see QuestDB as a long-term storage solution but rather as a speedy layer on top of my primary warehouse. I can see why high frequency guys love QuestDB - indeed very fast - but how could I archive data if I can’t compress data or even read Parquet.
  • Nicolas Hourcard

    Nicolas Hourcard

    2 months ago
    Yes, please send me an email and I will pass this on so we can explore this together. Are you currently using a warehouse and questdb together at the moment?