Nikolay and Michael discuss append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressing / removing / offloading the data eventually. Here are some links to things they mentioned:
Append-only https://en.wikipedia.org/wiki/Append-onlyOur...
Published 11/15/24
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/DenormalizationOur episode on materialized views...
Published 11/08/24