3 ms·
> to read one data point of a series you end up reading an array-length of data points you might not care about for this particular query. But DBs and FSs oper
by riku_iki 9y ago
> to read one data point of a series you end up reading an array-length of data points you might not care about for this particular query.
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.
- 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.