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.