Anomalies Under Load in PostgreSQL 2.0
summary
PostgreSQL performance can degrade even when queries are indexed and tuned; this talk examines anomalous behavior under load that isn’t fixed by classic query optimization. It analyzes causes of unexpected slowdowns in PostgreSQL 2.0 deployments and discusses diagnostic approaches and mitigations for cases where standard query-level fixes don’t help.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 16:00Global counters and MVCC
- 23:31Index problems
- 27:24Autovacuum and locks
- 33:09Data selection and autocommit
- 39:15Replication and startup
- 41:04Q&A
related talks
46mHow PostgreSQL Can Hurt You When You Least Expect It
57mQuery Logging and Workload Analysis
51mTypical application mistakes that lead to bloat in PostgreSQL
41mOptimizing your app by understanding your PostgreSQL database
51mPostgreSQL: Practical Examples of SQL Query Optimization
46mPostgreSQL Analytics: It's a Trap!
26mPostgreSQL performance tips you have never seen before V2.0
47mIdentifying Slow Queries and Fixing Them!