3 ms·

Really curious what "fast" is in this context. Milliseconds, seconds, minutes?

• atemerev 2y ago
  Full-range query with aggregations is around 40-60 seconds. Can be optimized, of course.
  • riku_iki 2y ago
    Base on numbers you put, you would need to have stable 50-100GB/s speed to your disc system to just read 3TB data in 40-60sec. Would you mind sharing your setup?
    • winrid 2y ago
      That's only if you read everything, and if none is in ram. With a columnar DB you can just scan the values of the column you need.
      • riku_iki 2y ago
        Then 3tb of total data volume is irrelevant. What relevant is size of column.
  • dleeftink 2y ago
    How about many-to-many comparisons? Interested in this use-case for fuzzy matching of many data records using a local db.