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/