An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better

1 · Timescale · Jan. 18, 2023, 4:38 p.m.
A continuous aggregate is similar to a PostgreSQL materialized view, speeding up queries. But rolling up (or downsampling) previously rolled up data can increase calculation speed while decreasing storage needs. Say hi to continuous aggregates on continuous aggregates, courtesy of Timescale 2.9....