---
title: "How We Made Real-Time Data Aggregation in Postgres Faster by 50,000%"
url: https://daily.dev/posts/how-we-made-real-time-data-aggregation-in-postgres-faster-by-50-000--dkcozhpyt
source_url: https://www.timescale.com/blog/how-we-made-real-time-data-aggregation-in-postgres-faster-by-50-000/
type: article
source: "TigerData (Creators of TimescaleDB)"
published: 2024-03-20T14:40:42.506Z
updated: 2024-05-09T09:06:08.895Z
tags: ["postgresql", "timescaledb"]
reading_time: 14
upvotes: 6
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# How We Made Real-Time Data Aggregation in Postgres Faster by 50,000%

**[TigerData \(Creators of TimescaleDB\)](https://daily.dev/sources/tigerdata)** · 14 min read · 6 upvotes · 0 comments

## Summary

Learn how real-time data aggregation in Postgres can be optimized through continuous aggregates, materialized views, and improving query planning.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.timescale.com/blog/how-we-made-real-time-data-aggregation-in-postgres-faster-by-50-000/>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments
- [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments
- [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments

---

Tags: [#postgresql](https://daily.dev/tags/postgresql), [#timescaledb](https://daily.dev/tags/timescaledb)

[View this post on daily.dev](https://daily.dev/posts/how-we-made-real-time-data-aggregation-in-postgres-faster-by-50-000--dkcozhpyt)