Create distributed hypertables

If you have a multi-node environment, you can create a distributed hypertable across your data nodes. First create a standard PostgreSQL table, and then convert it into a distributed hypertable.

important

You need to set up your multi-node cluster before creating a distributed hypertable. To set up multi-node, see the multi-node section.

Creating a distributed hypertable

On the access node of your multi-node cluster, create a standard PostgreSQL table:

CREATE TABLE conditions (
  time        TIMESTAMPTZ       NOT NULL,
  location    TEXT              NOT NULL,
  temperature DOUBLE PRECISION  NULL,
  humidity    DOUBLE PRECISION  NULL
);

Convert the table to a distributed hypertable. Specify the name of the table you want to convert, the column that holds its time values, and a space-partitioning parameter. For more information about space partitions, see the space-partitioning section.
```
SELECT create_distributed_hypertable('conditions', 'time', 'location');
```

Found an issue on this page?

Report an issue!

Keywords

hypertables distributed TimescaleDB

PreviousAbout distributed hypertables NextInsert data

Create distributed hypertables

Creating a distributed hypertable

Related Content