PgConf.Russia 2017 talks

Autonomous transactions in Postgres

Michael Shurutov
Postgres Professional, Database Maintenance Engineer

Michael graduated from the Altai State Technical University after I.I. Polzunova in 1998 year with a specialization in the Software of computer technology and automated systems. Since that time he has been dealing with maintenance of different software types successfully, including commercial and open free distributed ones, as well as unusual configurations.

  1. What is an autonomous transaction?
  2. An overview of autonomous transactions in "big" DBMS: Oracle.
  3. Autonomous transaction logic in Postgres Pro.
  4. An overview of emulation methods for autonomous transactions in PostgreSQL.
  5. Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.

VIDEO

Slides