Presented by:

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.

Jason Pedreza is a Senior PostgreSQL Database Specialist Solutions Architect at AWS with extensive experience orchestrating large-scale data transformations and migrations involving petabyte-scale environments. He has helped companies design and implement robust, enterprise-grade database solutions that combine performance, scalability, and cost efficiency. He partners with customers to design and implement highly scalable database solutions, leveraging his expertise in relational databases, data warehousing, and cloud-native technologies.

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:
2025 March 19 14:00 EDT
Duration:
50 min
Room:
Seminole C (General Session Room)
Conference:
Postgres Conference 2025
Language:
Track:
Variants and Cloud
Difficulty:
Medium