![Understanding PostgreSQL Aggregation and Hyperfunctions’ Design](/blog/content/images/size/w300/2024/01/PostgreSQL-Aggregation-and-Hyperfunctions-Design--1-.png)
![Understanding PostgreSQL Aggregation and Hyperfunctions’ Design](/blog/content/images/size/w300/2024/01/PostgreSQL-Aggregation-and-Hyperfunctions-Design--1-.png)
![Postgres Materialized Views, The Timescale Way](/blog/content/images/size/w300/2022/07/20220711_Materialized-views-and-CAGGS_Diagram_12-1.png)
![Function Pipelines: Building Functional Programming Into PostgreSQL Using Custom Operators](/blog/content/images/size/w300/2024/06/Function-pipelines--1-.png)
![How Percentiles Work (and Why They're Better Than Averages)](/blog/content/images/size/w300/2021/09/maxim-hopman-fiXLQXAhCfk-unsplash--1-.jpg)
![What Time-Weighted Averages Are and Why You Should Care](/blog/content/images/size/w300/2021/07/national-cancer-institute-zz_3tCcrk7o-unsplash--1-.jpg)
![Introducing Hyperfunctions: New SQL Functions to Simplify Working With Time-Series Data in PostgreSQL](/blog/content/images/size/w300/2021/07/ryan-stone-OlxJVn9fxz4-unsplash.jpg)
Introducing Hyperfunctions: New SQL Functions to Simplify Working With Time-Series Data in PostgreSQL
TimescaleDB hyperfunctions are pre-built functions for the most common and difficult queries that developers write today in TimescaleDB and PostgreSQL. Hyperfunctions help developers measure what matters in time-series data, which generates massive, ever-growing streams of information.
![Time-Series Analytics for PostgreSQL: Introducing the Timescale Analytics Project](/blog/content/images/size/w300/2021/01/alexander-andrews-4JdvOwrVzfY-unsplash.jpg)
Time-Series Analytics for PostgreSQL: Introducing the Timescale Analytics Project
We're excited to announce Timescale Analytics, a new project focused on combining all of the capabilities SQL needs to perform time-series analytics into one Postgres extension. Learn about our plans, why we're sharing it now, and ways to contribute your feedback and ideas.
![TimescaleDB 1.1 performance optimizations and PG11 support (beta)](/blog/content/images/size/w300/2018/12/present.jpeg)