News for hackers. Stuff that matters.

A comment on Timescale, an open-source time-series SQL database for PostgreSQL. Parent comment

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

[ Parent | on HN ]
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.

[ Parent | on HN ]