Presented by:

4511bccf8f05b830bd50c37e83138695

Dilip Kumar

from EnterpriseDB
No video of the event yet, sorry!

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
Requires Registration:
Yes (Registered: 0)

Happening at the same time:

  1. How to migrate logical replication slot to new primary during physical cluster switchover
  2. Start Time:
    2023 February 24 12:00

    Room:
    Robusta + Arabica

  3. Bug hunting in the postgres ecosystem
  4. Start Time:
    2023 February 24 12:00

    Room:
    Grand Victoria 2