Absorbing Load | Scaling Postgres 411
From Scaling Postgres by Creston Jamison
April 5, 2026 · 20 min · Episode 411
About this episode
This episode discusses techniques to manage excessive query load in Postgres, including BM25 text search and the use of CTEs.
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. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/411-absorbing-load/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
People in this episode
Host: Creston Jamison
Topics covered
- query load
- BM25 text search
- CTEs
- plan_cache_mode
- Postgres performance
Keywords
- query load
- BM25
- text search
- CTEs
- Postgres performance
Mentioned in this episode
Organizations: Scaling Postgres, pg_textsearch
More episodes of Scaling Postgres
- Postgres 19 Beta 1 Released | Scaling Postgres 420 · June 7, 2026 · 19 min
- The Dynamic Duo? | Scaling Postgres 419 · May 31, 2026 · 16 min
- Multigres Architecture | Scaling Postgres 418 · May 24, 2026 · 17 min
- 11 Security Issues | Scaling Postgres 417 · May 17, 2026 · 20 min
- Zero Bloat Postgres Queue | Scaling Postgres 416 · May 10, 2026 · 15 min
- pgBackRest Is Dead? | Scaling Postgres 415 · May 3, 2026 · 16 min
Explore listener stats, chart rankings, contacts and more on the Scaling Postgres podcast page.