Denormalization

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 en.wikipedia.org/wiki/Denormalization
• Our episode on materialized views postgres.fm/episodes/materialized-views
• Our episode on data model trade-offs postgres.fm/episodes/data-model-trade-offs
• Our episode with Markus Winand postgres.fm/episodes/modern-sql
• Universal Relation Data Modelling Considered Harmful (blog post by Michael Stonebraker and Álvaro Hernández) enterprisedb.com/blog/universal-relation-data-…
• Boyce–Codd normal form en.wikipedia.org/wiki/Boyce%E2%80%93Codd_norma…
• Our episode on slow count postgres.fm/episodes/slow-count
• pg_ivm github.com/sraoss/pg_ivm
• denorm github.com/rivethealth/denorm
• Postgres Materialized Views, The Timescale Way (blog post by David Kohn) timescale.com/blog/materialized-views-the-time…
• PgQ github.com/pgq/pgq
• Databases, types, and the relational model (by C.J. Date and Hugh Darwen) 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, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With special thanks to:
• Jessie Draws for the elephant artwork