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
on for the access node. By default, it is
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!