How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design

Re:How PostgreSQL aggregation works and how it inspired our ... by sgtfrankieboy on Thursday August 05, 2021 @02:48PM (#28077870)

Interesting article!

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.

[ Parent | on HN ]

Re:How PostgreSQL aggregation works and how it inspired our ... by djk447 on Thursday August 05, 2021 @03:02PM (#28078044)

Yes! They do fit together very well.

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!

[ Parent | on HN ]

Re:How PostgreSQL aggregation works and how it inspired our ... by mfreed on Thursday August 05, 2021 @03:36PM (#28078473)

We plan to release support for continuous aggregates on distributed hypertables in the next month or two.

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.

[ Parent | on HN ]