4 ms·

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.