Subtransactions | Postgres FM | Episode 73 (opens in new tab)

Nikolay and Michael discuss PostgreSQL subtransactions — what they are, and four issues they can cause at scale. Here are some links to things they mentioned:Subtransactions (docs) SAVEPOINT (docs) PostgreSQL Subtransactions Considered Harmful (blog post by Nikolay) Subtransactions and performance in PostgreSQL (blog post by Laurenz at Cybertec) Notes on some PostgreSQL implementation details (blog post by Nelson Elhage) Why we spent the last month eliminating PostgreSQL subtransactions (GitL...