Tag: orphaned prepared transactions

Enterprise PostgreSQL Solutions

Atomic Commit with 2 Phase Commit in FDW Distributed Setup

May 6, 2022

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

January 28, 2020

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

Recent Comments

    Canada Office

    Room 510 - 9850 King George Blvd, Surrey, BC V3T 0P9

    Email

    contact@highgo.ca

    Contact Number

    +1 (604) 781-6749

    ©  2024, HighGo Software Inc.