[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.