Scaling Postgres

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