Latest / More than a refresh: Conversations with the most interesting people you've never met
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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.