Performance Impact of Idle PostgreSQL Connections
Presented by:
Yaser Raja
Yaser Raja is a Senior Consultant with Professional Services team at Amazon Web Services. He works with customers to build scalable, highly available and secure solutions in AWS cloud. His focus area is homogenous and heterogeneous migrations of on-premise databases to AWS RDS and Aurora PostgreSQL.
No video of the event yet, sorry!
This presentation will provide an overview of how PostgreSQL manages connections and how idle connections impact performance.
Following areas will be covered in this presentation:
- Forking process used for each client connection
- OS resources utilization
- Results of various tests showing the resource utilization by idle connections
- Performance impact of idle connections
- Recommendations
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2020
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium