Materialized views
Nikolay and Michael discuss materialized views — what they are, the pros/cons, and some areas they can improve (and hopefully will!)
Postgres FM · Nikolay Samokhvalov and Michael Christofides
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Apologies, Michael's audio is not great in this, we'll hopefully be back to normal next week!
Here are links to a few things we mentioned:
- Materialized views (docs)
- Refresh materialized view (docs)
- Timescale blog post
- PlanetScale Boost (content warning: MySQL)
- Incremental Materialized Views with pg_ivm (video by Lukas Fittl)
- Articles on how to do your own incremental updates(?)
- Materialize (company)
- Materialize talk
- Incremental View Maintenance (Postgres wiki)
- Implementing Incremental View Maintenance (mailing list thread)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork