Materialized views

Postgres FM

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