Cannot buy tickets for ended conference: Postgres Conference 2025!

Presented by:

Anita Singh brings over two decades of experience architecting database solutions for mission-critical applications across diverse industries and technologies. For the past 5+ years at AWS, she has specialized in accelerating PostgreSQL adoption—particularly migrations from Oracle and SQL Server to PostgreSQL. She thrives in customer-focused environments, combining strong analytical capabilities with interpersonal skills to navigate complex technical challenges while inspiring teams to achieve their best.

Raj Jayakrishnan

Amazon Web Services

Raj Jayakrishnan is a Senior Database Specialist Solutions Architect with Amazon Web Services helping customers reinvent their business through the use of purpose-built database cloud solutions. Over 20 years of experience in architecting commercial & open-source database solutions in financial and logistics industry.

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