Scaling PostgreSQL With Amazon S3: An Object Storage for Low-Cost, Infinite Database Scalability

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 TimescaleDB 2.9.
Timescale 2.6 is now available, introducing two highly requested features by our community: compression for continuous aggregates and timezone support for continuous aggregates (the latter under experimental).
To reinforce our commitment to moving fast and not breaking things, we are introducing a new experimental schema as part of our release of TimescaleDB 2.4.
We're excited to announce TimescaleDB 1.7, which includes two major updates: PostgreSQL 12 support and Real-time Aggregates, as well as new capabilities in our Community edition 🥳! Get a quick look at what's new and how to get started.