This section contains some ideas for troubleshooting common problems experienced with continuous aggregates.
Continuous aggregates don't work on all queries. If you are using a function that continuous aggregates do not support, you see an error like this:
ERROR: invalid continuous aggregate view SQL state: 0A000
Continuous aggregates are supported for most aggregate functions that can
be parallelized by PostgreSQL, including the standard
AVG. However, aggregates using
ORDER BY and
DISTINCT cannot be used with continuous aggregates since they are not possible
to parallelize by PostgreSQL. TimescaleDB does not currently support the
Found an issue on this page?Report an issue!