Query data in distributed hypertables

You can query a distributed hypertable just as you would query a regular 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.

Found an issue on this page?

Report an issue!

Keywords

Related Content