This adds a new GUC parameter that automatically rolls back prepared transactions that have remained unresolved beyond the configured timeout. The cleanup is performed by the checkpointer process.

Edit
ID 6611
Title This adds a new GUC parameter that automatically rolls back prepared transactions that have remained unresolved beyond the configured timeout. The cleanup is performed by the checkpointer process.
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +513−1, All patches: +513−1
Tags Performance
Created 2026-03-24 08:59:02
Last modified 2026-03-24 08:59:03 (12 hours ago)
Latest email 2026-03-23 11:47:15 (yesterday)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version
Authors Nikhil Chawla (nchawla)
Reviewers Become reviewer
Committer
Links
Emails
[PATCH] Add prepared_orphaned_transaction_timeout GUC
First at 2026-03-23 11:47:15 by Nikhil Chawla <chawlanikhil24 at gmail.com>
Latest at 2026-03-23 11:47:15 by Nikhil Chawla <chawlanikhil24 at gmail.com>
Latest attachment (0001-Add-prepared_orphaned_transaction_timeout-GUC.patch) at 2026-03-23 11:47:15 from Nikhil Chawla <chawlanikhil24 at gmail.com>
    Attachment (0001-Add-prepared_orphaned_transaction_timeout-GUC.patch) at 2026-03-23 11:47:15 from Nikhil Chawla <chawlanikhil24 at gmail.com> (Patch: Yes)
History
When Who What
2026-03-24 08:59:03 Nikhil Chawla (nchawla) Attached mail thread CAAXajwDOvTwLQ=rO5hOKsR_VTikST1rN-moO46YhYEgsO00dqg@mail.gmail.com
2026-03-24 08:59:02 Nikhil Chawla (nchawla) Created patch record
Edit