Episode 122
Denormalization
Postgres FM · Nikolay Samokhvalov and Michael Christofides
November 8, 202435m 8s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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/Denormalization
- Our episode on materialized views https://postgres.fm/episodes/materialized-views
- Our episode on data model trade-offs https://postgres.fm/episodes/data-model-trade-offs
- 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/universal-relation-data-modelling-considered-harmful
- Boyce–Codd normal form https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form
- 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/materialized-views-the-timescale-way/
- 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/TTM/DTATRM.pdf
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With special thanks to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology