Warning

Multi-node support has been deprecated with TimescaleDB 2.13. This is the last version that includes multi-node support and it supports multi-node installations with PostgreSQL versions 13, 14, and 15.

Learn more about it here.

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.

  1. 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
    );
  2. 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.

    SELECT create_distributed_hypertable('conditions', 'time', 'location');

Keywords

Found an issue on this page?

Report an issue!