Re:Timescale, an open-source time-series SQL database for Po...
by gtrubetskoy on Friday August 11, 2017 @07:00PM
(#14995088)
> 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.
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.