Rare but extremely challenging Postgres Performance Problems. How to diagnose and overcome
Presented by:

Dilip Kumar
from
EnterpriseDB
Checkout the slides
In this talk, we will discuss some of the rare but challenging problems with PostgreSQL in heavily loaded systems. The main problems we are going to discuss are related to subtransaction overflow, multi-xact usage-related issues. We will also discuss how these problems become worst when they happen in presence of long-running queries. Then we will discuss some of the internal designs to understand these problems in more detail and we will also discuss some of the work happening in the PostgreSQL community around this area.
- Date:
- 2023 February 24 - 12:00
- Duration:
- 45 min
- Room:
- Grand Victoria 1
- Conference:
- PGConf India, 2023
- Language:
- Track:
- Database Engine Developers
- Difficulty:
- Medium
- Bug hunting in the postgres ecosystem
- Start Time:
- 2023 February 24 12:00
- Room:
- Grand Victoria 2
- Migrate logical replication during physical cluster switchover
- Start Time:
- 2023 February 24 12:00
- Room:
- Robusta + Arabica