Postgres Database Performance
summary
Discusses Postgres database performance and scaling, covering concepts and goals of scaling, infrastructure and schema design, application code and architecture impacts, common architectural pitfalls, and what performance testing can and cannot reveal. Describes monitoring and observability for Postgres and gives an example of managing Postgres performance using EDB tools.
AI-written summary · about
chapters (28)
- 0:00Introduction
- 1:57What is DB performance
- 3:00Infrastructure and architecture role
- 6:32Tech evolution and challenges
- 13:07Slow DB vs application
- 15:17Speed and throughput concepts
- 18:10Network latency impact
- 25:06Query response times and stability
- 28:46Disk access and buffers
- 31:16Query optimization problems
- 34:29Optimizer stats and MVCC
- 36:36Table and index bloat
- 38:02CPU and resource management
- 41:18Cloud specs and limits
- 44:33Disk issues and queues
- 45:58Caching and system limits
- 46:43CPU usage vs response times
- 48:29Throughput and bottlenecks
- 51:40DB design and scaling
- 54:55App hygiene for DB
- 59:23Hot and cold data separation
- 1:05:21VACUUM importance in PostgreSQL
- 1:08:23DB performance testing
- 1:15:40Performance test pitfalls
- 1:19:49Disk role in performance
- 1:20:30Performance diagnostics tools
- 1:31:46Locking issues identification
- 1:36:24Query optimization and Index Advisor
related talks
30mManaging Postgres at scale: Challenges, Tools & Techniques
51mPostgreSQL Panel Discussion
37mPostgres at Any Scale
36mPostgres at any Scale
25mData-intensive PostgreSQL: Three ways to scale
18mPower Hour, Managing Databases at Scale – Peter Zaitsev
11mThe Seven Principles for Making a PostgreSQL DB Work Fast
41mApplication Development Challenges with Postgres