Materialized views | Postgres.FM 021 |
Michael and Nikolay discuss materialized views — what they are, the pros/cons, and some areas they can improve (and hopefully will!)
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) https://www.postgresql.org/docs/curre...
* Refresh materialized view (docs) https://www.postgresql.org/docs/curre...
* Timescale blog post https://www.timescale.com/blog/how-po...
* PlanetScale Boost (content warning: MySQL) https://planetscale.com/blog/how-plan...
* Incremental Materialized Views with pg_ivm (video by Lukas Fittl) • 5mins of Postgres E16: Incremental Ma...
* Articles on how to do your own incremental updates(?)
* Materialize (company) https://materialize.com/
* Materialize talk • Materialize: A Streaming SQL Database...
* Incremental View Maintenance (Postgres wiki) https://wiki.postgresql.org/wiki/Incr...
* Implementing Incremental View Maintenance (mailing list thread) https://www.postgresql.org/message-id...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.