Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306

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.

Content Discussed

• Postgres Indexes, Partitioning and LWLock:LockManager Scalability
• Waiting for Postgres 17: Configurable SLRU cache sizes for increased performance
• PgBouncer 1.22.1
• Isolation Anomalies in PostgreSQL
• Rails + Postgres
• Psycopg2 vs Psycopg3 Performance Benchmark
• CloudNativePG Recipe 1 - Setting up your local playground in minutes
• Tips for tuning Postgres LIKE & ILIKE queries via pg_trgm on Azure
• Why I Love psql – PostgreSQL Terminal.
• Comparing Postgres Managed Services: AWS, Azure, GCP and Supabase
• PGSQL Phriday #016: Tuning That One Big Query
• What's 'Rows Removed By Filter' all about — Part Two
• From dbf to PostgreSQL with Python
• Can you use ltree for Nested Place Data?
• Divya Sharma
• Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen
• What’s in a name? Hello POSETTE: An Event for Postgres 2024
• PostgREST Aggregate Functions
• PostgreSQL security – Password Reuse Policy
• List of PostgreSQL® AI Projects and Resources
• Percona Operator for PostgreSQL is Red Hat OpenShift Certified
• Partitioning by reference – Oracle vs PostgreSQL
• Open source key areas for digital autonomy
• Talk: State of the Extension Ecosystem
• Introducing pganalyze Index Advisor 3.0 - A workload-aware system for finding missing indexes in Postgres
• Build a question-answer bot natively using Postgres extensions
• Migrate from Heroku Postgres to Crunchy Bridge
• Introducing New Cloud Regions and How We Choose Them
• Building Iterative Compression for Dynamic Applications

YouTube Video

Podcast Audio