Conference Schedule - PGConf.EU 2022
Practical transactions theory for PostgreSQL users
Room: Berlin 1
We all remember the day we realized a database transaction is a slightly more fundamental concept than we thought. It is not just BEGIN/COMMIT/ROLLBACK syntax sugar in our programs that of course makes them more complex and slows them down. And it is not just an outdated mechanism which somehow survived challenges of our modern schemaless noACID world. Transactions are a powerful mechanism of making the programs faster and more efficient but they are heavily based in complex math, which is far away from your daily database routine. In this talk I will give a brief introduction to the theoretical concepts around ACID transactions and related algorithms -- two-phase locking, deadlock detection, MVCC, recovery algorithms -- and highlight in a more practical way how they are applicable to PostreSQL. Finally, I will provide practical advice on working with transactions from your application.