Learn how we accelerated real-time data aggregation in PostgreSQL by 50,000 % by tweaking the query planner.

PostgreSQL insights for every developer journey. Get tips and tutorials on database performance, query optimization, time-series data, and more—from real-time analytics and IoT data management to events and vector embeddings. 


TigerData (Creators of TimescaleDB)

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

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

Speeding Up Data Aggregation in Postgres: Continuous Aggregates?

Query Planning in Postgres and Function Volatility

Query Planning When a Real-Time Continuous Aggregate Is Used

Optimizing the Query Planning in PostgreSQL