Absorbing Load | Scaling Postgres 411

In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode.

Content Discussed

• Absorbing the Load
• pg_textsearch 1.0: How We Built a BM25 Search Engine on Postgres Pages
• Good CTE, bad CTE
• The Hidden Behavior of plan_cache_mode
• Long-running transactions
• pg_service.conf: the spell your team forgot to learn
• The Agentic Confusion: Why I Keep My Postgres Control Plane Deterministic
• High memory usage in Postgres is good, actually
• Waiting for PostgreSQL 19 – Add UPDATE/DELETE FOR PORTION OF
• Waiting for PostgreSQL 19 – json format for COPY TO
• Patroni: Cascading Replication with Standby Cluster
• Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversion
• Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About!
• Postgres Performance: Why Peak Throughput Benchmarks Miss the Real Problem
• The Subtle Shift: Understanding NOT VALID vs. NOT ENFORCED Constraints in PostgreSQL
• Chess in Pure SQL
• CloudNativePG 1.29.0 Released!
• pg_background v1.9: a calmer, more practical way to run SQL in the background
• pg_duckpipe: What's New in March 2026
• Contributions for week 12, 2026
• Prairie Postgres Second Developers’ Summit and Why You Should Participate
• My First Self-Organized PostgreSQL Meetup in Vienna
• Document Databases: Be Honest
• Replicating CrystalDBA With pgEdge MCP Server Custom Tools
• Graceful degradation in Postgres
• Zero-Downtime Patching Part 1: Prewarming
• Supabase docs over SSH

YouTube Video

Podcast Audio