Unleashing PostgreSQL Performance: Troubleshooting Techniques for Common Use Cases in RDS & Aurora PostgreSQL
Presented by:
Ranjan Burman
Ranjan Burman is a Senior PostgreSQL Database Specialist Solutions Architect with Amazon Web Services helping customers in designing robust and scalable database solutions. Over 18 years of experience in architecting database solutions for mission-critical applications across various industries and database technologies solving most complex and high scale data challenges.
No video of the event yet, sorry!
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 impacts of no partition pruning, idle connections, subtransactions, query memory usage, and etc.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Variants and Cloud
- Difficulty:
- Medium