
MTAR T3D Sessions: Real-Time Materialized Views in PostgreSQL
What would it take for PostgreSQL materialized views to stay current as the underlying data changes?
In this Postgres Wishlist episode, Brian joins JD to explore his request for real-time materialized views. Brian has built trigger-based solutions for simpler cases, but keeping aggregate results up to date becomes more involved as queries grow complex. For applications such as a live scoring site, waiting for the next refresh means showing results that no longer reflect the latest activity.
The conversation explores possible approaches and their trade-offs, then turns to a more targeted request: refreshing only the relevant portion of a materialized view.
If only some customers have new activity, why recalculate results for everyone? Brian and JD consider what more flexible refresh behavior could offer and the implementation questions that remain open.
Więcej odcinków z kanału "More than a refresh: Conversations with the most interesting people you've never met"



Nie przegap odcinka z kanału “More than a refresh: Conversations with the most interesting people you've never met”! Subskrybuj bezpłatnie w aplikacji GetPodcast.








