3 ms·
> But DBs and FSs operate on pages of data and not individual records, so you will be reading that row anyway, and likely much more. Yes, when dealing with dat
by gtrubetskoy 9y ago
> But DBs and FSs operate on pages of data and not individual records, so you will be reading that row anyway, and likely much more.
Yes, when dealing with database performance understanding this goes with the territory.
The "game" here is to organize data in such way that the stuff you read inadvertently is something that you will need eventually (as in in a few microseconds). This is where things like CLUSTER and BRIN indexes become important, and this is also why partitioning is a win.