Hypertables

    With hypertables, TimescaleDB makes it easy to improve insert and query performance by partitioning time-series data on its time parameter. Behind the scenes, the database performs the work of setting up and maintaining the hypertable’s partitions. Meanwhile, you insert and query your data as if it all lives in a single, regular PostgreSQL table.

    Learn more about:

    TimescaleDB handles all this for you so you can focus on your application.

    When to use a hypertable in TimescaleDB

    For example, you might have:

    • A hypertable to record stock asset prices over time, and a regular table to record ticker symbols and names for each asset
    • A hypertable to record truck GPS coordinates over time, and a regular table to record the make, model, and age of each truck