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.