Presented by:

I have over two decades of experience in architecting database solutions for mission-critical applications across various industries and database technologies.I have become an appreciator of PostgreSQL over past 5+ years and help customers accelerate their adoption of Postgres, esp with migrations from Oracle/SQLServer. I am a seasoned IT professional dedicated to driving success in dynamic environments. I have a proven track record of leading and inspiring teams to achieve their best in collaborative, customer-focused settings. My versatility as a team player, combined with strong analytical and interpersonal skills, enables me to navigate complex challenges effectively.

Badge pic

Sukhpreet Bedi

Amazon Web Services

Sukhpreet Kaur Bedi is a Senior PostgreSQL Specialist SA at AWS focusing on Amazon RDS/Aurora PostgreSQL engines. She helps customers innovate on the AWS platform by building highly available, scalable, and secure database architectures.

No video of the event yet, sorry!

Extract: Understanding Database Statistics in PostgreSQL Understanding Database Statistics in Postgres Session Description Database statistics play a crucial role in optimizing query performance and overall database health in Postgres. This session will provide an in-depth look at the different types of database statistics maintained by Postgres, how they are collected and used by the query optimizer, and techniques for monitoring and managing these statistics.

Key topics covered will include:

Overview of Postgres statistics: table statistics, index statistics, extended statistics, and more How the Postgres query optimizer uses statistics to estimate plan costs and choose execution plans Techniques for manually updating statistics, including the ANALYZE command Monitoring and troubleshooting statistics-related performance issues Best practices for maintaining healthy database statistics in production environments Attendees will come away with a deep understanding of the importance of database statistics in Postgres and practical knowledge for optimizing their Postgres deployments.

Date:
2024 November 6 09:40 PST
Duration:
20 min
Room:
Ops: 421
Conference:
Seattle 2024
Language:
Track:
Ops
Difficulty:
Medium