Troubleshooting continuous aggregates

This section contains some ideas for troubleshooting common problems experienced with continuous aggregates.

Queries that work on regular tables, fail on 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:

  1. ERROR:  invalid continuous aggregate view
  2. SQL state: 0A000

Continuous aggregates are supported for most aggregate functions that can be parallelized by PostgreSQL, including the standard aggregates like SUM and 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 FILTER clause.