Schedule - PGDay Chicago 2023

    You are using subtransactions and don’t even know it.

    Date: 2023-04-20
    Time: 09:55–10:45
    Room: Halsted Hub
    Level: Advanced
    Feedback: Leave feedback

    Are you using savepoints? Do you use exception clauses in your PL/pgSQL code? Do you use database drivers with default configurations? If you answered yes, you are using subtransactions. While useful, you should be aware of the hidden dangers.

    In this talk, we will explore best practices for managing subtransactions from lessons we’ve learned at AWS from customers and our own PostgreSQL usage. We will discuss what a subtransaction is, how they can occur, efficient use as your workload scales and effective monitoring.


    Sami Imseih
    Shawn McCoy