Denormalization | Postgres.FM 122 | скачать в хорошем качестве

Denormalization | Postgres.FM 122 |

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!] Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across recently. Here are some links to things they mentioned: Denormalization https://en.wikipedia.org/wiki/Denorma... Our episode on materialized views https://postgres.fm/episodes/material... Our episode on data model trade-offs https://postgres.fm/episodes/data-mod... Our episode with Markus Winand https://postgres.fm/episodes/modern-sql Universal Relation Data Modelling Considered Harmful (blog post by Michael Stonebraker and Álvaro Hernández) https://www.enterprisedb.com/blog/uni... Boyce–Codd normal form https://en.wikipedia.org/wiki/Boyce%E... Our episode on slow count https://postgres.fm/episodes/slow-count pg_ivm https://github.com/sraoss/pg_ivm denorm https://github.com/rivethealth/denorm Postgres Materialized Views, The Timescale Way (blog post by David Kohn) https://www.timescale.com/blog/materi... PgQ https://github.com/pgq/pgq Databases, types, and the relational model (by C.J. Date and Hugh Darwen) https://www.dcs.warwick.ac.uk/~hugh/T... ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm   / postgresfm  , @samokhvalov   / samokhvalov   and @michristofides   / michristofides   ~~~ Postgres FM is produced by: Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.