Real-time analytics
Postgres FM
00:00
Exploring materialized views and limitations in real-time analytics
This chapter explores the significance of materialized views and the shortcomings of PostgreSQL in the realm of real-time analytics. The speakers discuss the need for understanding PostgreSQL's capabilities, suggest experimenting with larger datasets, and emphasize the benefits of index-only scans and aggressive AutoVacuum tuning. They also mention three missing features: asynchronously detached sessions, fully automated partitioning, and incremental refresh for materialized views.
Transcript
Play full episode
