Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss how the SLRU cache and LWLock:LockManager set scalability limits for Postgres, a new release of PgBouncer, and different transaction isolation levels.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:16 - Postgres Indexes, Partitioning and LWLock:LockManager Scalability
04:54 - Waiting for Postgres 17: Configurable SLRU cache sizes for increased performance
06:42 - PgBouncer 1.22.1
07:20 - Isolation Anomalies in PostgreSQL
09:56 - Rails + Postgres
10:34 - Psycopg2 vs Psycopg3 Performance Benchmark
11:23 - CloudNativePG Recipe 1 - Setting up your local playground in minutes
11:45 - Tips for tuning Postgres LIKE & ILIKE queries via pg_trgm on Azure
12:36 - Why I Love psql – PostgreSQL Terminal.
12:57 - Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase
13:25 - PGSQL Phriday #016: Tuning That One Big Query
14:02 - Outro

#postgres #postgresql