Optimizing High-Contention Writes in PostgreSQL
summary
The talk examines optimizing PostgreSQL for high-contention write workloads, discussing how standard benchmarks (pgbench) shaped PostgreSQL into a pgbench-optimized DBMS and how performance tweaks that help one workload can harm others. It covers measurement and tuning approaches for write-heavy contention scenarios in PostgreSQL, drawing on pgbench-based evaluation and practical trade-offs.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:12High-contention problem
- 9:33Testing and benchmarks
- 17:24Transaction isolation issues
- 26:18Lock optimization
- 30:12Counter practical solution
- 33:23PostgreSQL community
- 40:13Companies and community
- 44:06Future and conclusions
related talks
31mDemanding the impossible rigorous database benchm
43mTuning PostgreSQL for High Write Workloads
45mTuning Hardware and the Operating System: Benchmarking on PostgreSQL
04mRoad to Percona Live 2022 - Yahav Biran - PostgreSQL Talk
51mPostgreSQL: Practical Examples of SQL Query Optimization
43mPostgreSQL in the cloud: Theory and Practice
50mPerformance Archaeology
49mCan PostgreSQL Compete with Analytics Specialists?