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!