Presented by:

Chandra Pathivada is a Senior Database Specialist Solutions Architect with Amazon Web Services. He works with AWS RDS team, focusing on Opensource database engines like RDS PostgreSQL and Aurora PostgreSQL and Babelfish for Aurora PostgreSQL. He enjoys working with customers to help design, deploy, and optimize relational database workloads on AWS

No video of the event yet, sorry!

In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ultimately improving the efficiency of your PostgreSQL database. Whether you're a database administrator, developer, or simply interested in database performance, this session provides valuable insights into maximizing the benefits of indexing in PostgreSQL.

Date:
2024 April 17 16:10 PDT
Duration:
50 min
Room:
Santa Clara
Conference:
Postgres Conference 2024
Language:
English
Track:
Essentials
Difficulty:
Intermediate