I have a massive live table that I would like to continuously aggregate. The live table is massive, so it would take hours to fully populate the materialized view for the continuous aggregate.

I currently have a hypertable that is partitioned only by time and I want to add an extra dimension e.g. account_id.

Recently we switched to timescaledb for our timeseries data. Basic quries seem to work fine but we have an engine simulator that needs to fetch data from multiple tables, aggregate them and sort them before streaming. However, the below code takes more than a minute which is a problem since we need to stream at least a year’s worth of data. Below is my query: