Materialized views | Postgres.FM 021 |
Vložit
- čas přidán 24. 11. 2022
- 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) www.postgresql.org/docs/curre...
* Refresh materialized view (docs) www.postgresql.org/docs/curre...
* Timescale blog post www.timescale.com/blog/how-po...
* PlanetScale Boost (content warning: MySQL) planetscale.com/blog/how-plan...
* Incremental Materialized Views with pg_ivm (video by Lukas Fittl) • 5mins of Postgres E16:...
* Articles on how to do your own incremental updates(?)
* Materialize (company) materialize.com/
* Materialize talk • Materialize: A Streami...
* Incremental View Maintenance (Postgres wiki) wiki.postgresql.org/wiki/Incr...
* Implementing Incremental View Maintenance (mailing list thread) 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 Postgres.fm to find audio-only podcast episodes, edited for convenient listening. - Věda a technologie
It would be nice if someone did something like Materialize (company) but with nats instead of kafka. nats is simple to host.
The continuous interruptions of the guy on the left by the guy on the right make this very difficult to listen. I'm at @21:44, and this still hasn't improved. Next time, please, please make sure that your colleague has _at least_ finished his sentence before you start talking over him.
Thanks for the feedback; there is something that has to be improved, agreed.
@@NikolaySamokhvalov As someone who has been often criticized for interrupting people myself, I know that this can be a super difficult behavior to change. Many kudos for wanting to work on this. 🙌
It's probably hard over the internet with the latency.