PostgreSQL performance tips you have never seen before V2.0
summary
PostgreSQL tips that change actual numbers: loading PL/R/PostGIS into shared_preload_libraries cuts first-call latency from ~229 ms to under 1 ms and speeds PostGIS first calls ~3x; switching wal_level to minimal and raising max_wal_size shrinks 100k transactions from ~135 MB to ~82 MB of WAL; setting static-index FILLFACTOR to 100% trims index size ~10%; setting join_collapse_limit avoids huge planner overhead (planning was 6× execution in an example), and tuning function costs drops a case from ~2.6s to ~2.1s.
AI-written summary · about
chapters (8)
- 0:00Intro
- 1:41Goal of this talk
- 2:34Creating connections
- 5:33PostGIS
- 6:35Storing data
- 15:31Enforcing join order
- 20:07Executing more efficiently
- 24:50Summary
related talks
25mPostgreSQL performance tips you have never seen before
45mPerformance tricks you have never seen before 2.0
42mPostgreSQL Tips & Tricks For App Devs
43mPostgres Performance: From Slow to Pro
24mTop 5 PostgreSQL Query Tuning Tips
25mScaling PostgreSQL Beyond Query Optimization
56mPerformance Improvements in PostgreSQL9 2
50mImproving Postgres' Efficiency