I was wondering if there plans for supporting Continuous Aggregates on Distributed hypertables? Its currently listed as not supported under the limitations docs page.
I think the two would fit together perfectly as it will allow users to aggregate very large tables.
There are plans to do that, I'm not sure the exact timeline, I think it's in the design phase now.
We do already support partitionwise aggregation, and this meshes very well with that, so that you're sending much, much less data back over the network between the data node and access node when you're trying to do things like percentiles. But I agree that continuous aggregate support will be an even bigger win!
Initially version will support case where the raw data is a distributed hypertable, while the cagg table is a hypertable on the access node. Then follow-up with support where the cagg table can be distributed as well.
We are simultaneously working on support for compressed continuous aggregates as well, which we are targeting the same timeframe.