Troubleshoot PostgreSQL performance by use case
Presented by:
Wanda He
Wanda He is a Prin. Database Specialist Solutions Architect at Amazon Web Services (AWS). She works with customers on design, deploy, and optimize relational databases on AWS. Wanda has been working with relational database for over 20 years. Previously, she was a member of of Microsoft SQL Server Customer Advisory Team. At AWS, she specialized in RDS/Aurora PostgreSQL, RDS SQL Server, and RDS on Outposts.
Thuymy Tran
The performance of your PostgreSQL database might be affected for multiple reasons, such as hardware (CPU, memory, disk) sources, application access pattern, suboptimal query plans, and etc. This session presents use cases of common PostgreSQL performance problems, discusses approaches and methodologies for “peeling the onion”, and identifies solutions. Use cases cover include idle connections, subtransactions, query memory usage, and etc.
- Date:
- 2024 April 17 12:10 PDT
- Duration:
- 50 min
- Room:
- Santa Clara
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Essentials
- Difficulty:
- Intermediate