Speed of work of CAgg is slow after creation of second CAgg for hypertable

TimescaleDB and PostgreSQL
,
1

Hi! Today I add one more CAgg for the hypertable and following processes are slowdowned:

  1. CALL refresh_continuous_aggregate().
  2. SELECT * FROM CAgg WHERE date_ >= ‘2022-01-01’ AND date_ < ‘2022-10-01’ ORDER BY col1, col2, col3;
    Is this a bug or or did I miss something?
    CAgg was created WITH NO DATA.

PostgreSQL 12.8
TimescaleDB 2.8.0

1 Like
2

Sorry to be slow to respond here @LuxCore could you elaborate a bit more on what things look like now?

Also, could you share an EXPLAIN ANALYZE for the slow query? I’m wondering if you have bumped into this [Bug]: Very slow performance of cagg_watermark function, when running multiple queries in parallel on cagg with real time aggregation on · Issue #4699 · timescale/timescaledb · GitHub

This is another issue with a similar feel for example Very slow query planning times on continuous aggregates - #2 by purplegrounded