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