Mike Freedman
Jul 24, 2017 · 1 min read

Hi rohangulati: You query a hypertable in TimescaleDB just like you would any standard table. That is, we’ve hidden the fact / abstracted away the fact that all the data is partitioned into smaller chunks, and it just looks like a standard query to you.

http://docs.timescale.com/api#select

The query planner then knows how to properly execute a query on which chunks (based on the query and chunk constraints) and merge the results.

Same on the insert side: You just write one row or even many thousands of rows in a standard INSERT to the hypertable, the database figures out how to route this insert to its proper chunks (and possibly “split” the one insert across multiple chunks if needed).

    Mike Freedman

    Written by

    Co-founder/CTO of @timescaledb. Professor of Computer Science, Princeton University.