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

Presented by:

4511bccf8f05b830bd50c37e83138695

Dilip Kumar

from Google

Dilip Kumar, Staff Software Engineer at Google and a PostgreSQL contributor!

Dilip is specialised in database internals and has made significant contributions to PostgreSQL, particularly in parallel query, performance, scalability enhancements, and logical replication. His notable contributions include implementing Logical Replication for In-Progress Transactions, Optimizing SLRU, Introducing Parallel Bitmap Heap Scan and Parallel Merge Join, and enabling "Block-Level CREATE DATABASE Support." Currently, he is exploring the implementation of global indexes for PostgreSQL.

Dilip is also an active participant in PostgreSQL open-source conferences, sharing insights and fostering collaboration within the community.

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

Happening at the same time:

  1. Bug hunting in the postgres ecosystem
    2. Start Time:
    2023 February 24 12:00

    Room:
    Grand Victoria 2

  2. Migrate logical replication during physical cluster switchover
    3. Start Time:
    2023 February 24 12:00

    Room:
    Robusta + Arabica