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 the past 5+ years and help customers accelerate their adoption of Postgres, especially 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 and strong analytical and interpersonal skills enable me to navigate complex challenges effectively.

Jrajk photo

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.

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