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

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss issues with locking tables, foreign keys and slow decimals. We also cover when joins use memoize.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:27 - OK, sometimes you can lock tables.
01:53 - A foreign key pathology to avoid
03:08 - How slow is DECIMAL, anyway?
03:56 - Using Memoize to speed up joins between two Postgres tables
05:12 - usql: universal psql?
05:58 - How to Solve Advent of Code 2022 Using Postgres - Day 13
06:10 - Building a PostgreSQL Wire Protocol Server using Vanilla, Modern Java 21
06:42 - Debugging PostgreSQL CI failures faster: 4 tips
07:43 - Auditing
08:02 - Miroslav Šedivý
08:14 - Rubber Duck Dev Show Episode 70 | Teaching Young Developers with Melissa Amaya
08:41 - Outro

#postgres #postgresql