Postgres FM Real-time analytics
Feb 17, 2023
The podcast discusses real-time analytics in Postgres, including the challenges of integration and the importance of partitioning and analytics databases. They explore materialized views in real-time analytics and discuss estimates and Autovacuum for performance optimization in Postgres.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 3min
Real-Time Analytics and Challenges in Integration
02:57 • 17min
The Importance of Partitioning for Real-Time Analytics and Query Performance
20:27 • 5min
Analytics Databases for Postgres and Real-time Analytics
25:53 • 3min
Exploring materialized views and limitations in real-time analytics
28:53 • 3min
Using Estimates and Autovacuum in Postgres for Performance
31:48 • 2min