[atemerev]

Full-range query with aggregations is around 40-60 seconds. Can be optimized, of course.

[riku_iki]

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]

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]

Then 3tb of total data volume is irrelevant. What relevant is size of column.

[dleeftink]

How about many-to-many comparisons? Interested in this use-case for fuzzy matching of many data records using a local db.