![Building Iterative Compression for Dynamic Applications](/blog/content/images/size/w300/2024/03/2.png)
![Building Iterative Compression for Dynamic Applications](/blog/content/images/size/w300/2024/03/2.png)
![How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)](/blog/content/images/size/w300/2022/06/dog-racing-2878713_1920--1-.jpg)
![Improving DISTINCT Query Performance Up to 8,000x on PostgreSQL](/blog/content/images/size/w300/2021/05/pexels-pixabay-373543.jpg)
![Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation](/blog/content/images/size/w300/2020/05/mana5280-dkeOcAkors4-unsplash.jpg)
Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation
Real-time aggregates (released with TimescaleDB 1.7) build on continuous aggregates' ability to increase query speed and optimize storage. Learn what's new, details about how they work, and how to get started.
![OrderedAppend: An optimization for range partitioning](/blog/content/images/size/w300/2019/07/blogorderedappend.jpg)
![Implementing constraint exclusion for faster query performance](/blog/content/images/size/w300/2019/07/Timescale-1.png)
![Mind the gap: Using SQL functions for time-series analysis](/blog/content/images/size/w300/2019/01/20190123_TimeBucketGapFill.jpg)
![Grafana & TimescaleDB: Enhancing time-series exploration and visualization](/blog/content/images/size/w300/2019/01/Screen-Shot-2019-01-22-at-4.28.57-PM-2.png)