Episode 249 Locking Tables, Foreign Key Issue, Slow Decimals, Memoize & Joins

<p>In this episode of Scaling Postgres, we discuss issues with locking tables, foreign keys and slow decimals. We also cover when joins use memoize.</p> <p>Subscribe at <a href= "https://www.scalingpostgres.com">https://www.scalingpostgres.com</a> to get notified of new episodes.</p> <p>Links:</p> <ul> <li><a href= "https://thebuild.com/blog/2023/01/16/ok-sometimes-you-can-lock-tables/"> https://thebuild.com/blog/2023/01/16/ok-sometimes-you-can-lock-tables/</a></li> <li><a href= "https://thebuild.com/blog/2023/01/18/a-foreign-key-pathology-to-avoid/"> https://thebuild.com/blog/2023/01/18/a-foreign-key-pathology-to-avoid/</a></li> <li><a href= "https://thebuild.com/blog/2023/01/15/how-slow-is-decimal-anyway/">https://thebuild.com/blog/2023/01/15/how-slow-is-decimal-anyway/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-memoize-speed-up-joins">https://pganalyze.com/blog/5mins-postgres-memoize-speed-up-joins</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/usql-universal-psql/">https://www.cybertec-postgresql.com/en/usql-universal-psql/</a></li> <li><a href= "https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-13"> https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-13</a></li> <li><a href= "https://gavinray97.github.io/blog/postgres-wire-protocol-jdk-21">https://gavinray97.github.io/blog/postgres-wire-protocol-jdk-21</a></li> <li><a href= "https://www.citusdata.com/blog/2023/01/18/debugging-postgres-ci-failures-faster-4-tips/"> https://www.citusdata.com/blog/2023/01/18/debugging-postgres-ci-failures-faster-4-tips/</a></li> <li><a href= "https://postgres.fm/episodes/auditing">https://postgres.fm/episodes/auditing</a></li> <li><a href= "https://postgresql.life/post/miroslav_sedivy/">https://postgresql.life/post/miroslav_sedivy/</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/70-teaching-young-developers-with-melissa-amaya/"> https://www.rubberduckdevshow.com/episodes/70-teaching-young-developers-with-melissa-amaya