|
|
|
|
|
|
by mfreed
1693 days ago
|
|
|
Yep! And in fact, that's exactly what TimescaleDB supports - things like hyperloglog to support approximate count distinct, including as part of continuous aggregates. [0] This blog post - "How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design" - provides a really nice description of how our the API design of some of our analytical functions are motivated by the ability to "split" processing into the "pre-aggregation" and "finalization" steps, with the blog post focusing on the example of percentile approximation. (I think it was on HN a while back as well.) [1] [0] https://blog.timescale.com/blog/introducing-hyperfunctions-n... [1] https://blog.timescale.com/blog/how-postgresql-aggregation-w... |
|
|