An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better
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.
How to Design a Better Developer Experience for Time-Series Data: Our Journey With Timescale's UI
Designing a delightful, user-centered UI is a huge part of building a seamless developer experience for time-series data. Join us on a journey through the evolution of the Timescale UI.
How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster, while requiring 60 % less storage (on average).