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.

You can query a distributed hypertable just as you would query a standard hypertable or PostgreSQL table. For more information, see the section on writing data.

Queries perform best when the access node can push transactions down to the data nodes. To ensure that the access node can push down transactions, check that the enable_partitionwise_aggregate setting is set to on for the access node. By default, it is off.

If you want to use continuous aggregates on your distributed hypertable, see the continuous aggregates section for more information.

Keywords

Found an issue on this page?

Report an issue!