AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Explore practical PostgreSQL performance tuning techniques through this AWS re:Invent 2025 conference talk that focuses on real-world workload optimization. Dive deep into engineering-based approaches to identify and resolve common performance pitfalls that silently degrade database systems. Discover how excessive indexes negatively impact write throughput, understand the reasons behind HOT update failures, and learn how vacuum behavior can create system bottlenecks. Master the use of Query Plan Management (QPM) and pg_hint_plan for maintaining plan stability, while developing skills to decode wait events that reveal hidden performance issues. Through practical SQL examples and detailed system insights, gain the expertise needed to tune PostgreSQL databases for predictable, high-performance workloads in production environments.
