Tag: orphaned prepared transactions

Enterprise PostgreSQL Solutions

Atomic Commit with 2 Phase Commit in FDW Distributed Setup

1. Introduction PostgreSQL’s 2 phase commit (2PC) feature allows a database to store the details of a transaction on disk without committing it. This is done by issuing PREPARE TRANSACTION [name] command at the end of a transaction block. When the user is ready to commit, he/she can issue COMMIT PREPARED [name] where [name] should…
Read more

Understanding Prepared Transactions and Handling the Orphans

Prepared transactions are a key feature of PostgreSQL. Understanding what this feature offer and handling any potential pitfalls is critical to maintaining a system that is reliable. So let’s take a dive into what prepared transactions are all about.  A Little Bit About Transactions In a database system, transactions are a way of processing all…
Read more