search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
16.83k stars 852 forks source link

[Feature]: Allow omission of time_bucket and aggregation when creating continuous aggregate #6960

Open ewoolsey opened 1 month ago

ewoolsey commented 1 month ago

What problem does the new feature solve?

For many use cases there is no need to aggregate data. In this case the cagg acts simply as a real time materialized view. It would be extremely convenient to have caggs generalized in this way.