Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.
