This is an external article made in collaboration with another source. Click the button below to view the whole article.
You may have heard that “data is the new oil.” By itself, data is unrefined and not valuable, but given processing and refinement, it becomes precious. We gain insights into our products, applications, and customers by exploring our data. PostgreSQL exposes aggregate functions that give us the tools to transform and process our data to provide meaning.
In this article, we’ll take a look at how to use SQL aggregate functions, the pitfalls, and how Timescale gives us advanced tooling to aggregate time-series data.
One of the Postgres posts on the site. The full track, grouped by topic, lives on the guide page .