Denormalization

Postgres FM

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