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) Needs rebase! Needs rebase since 1 week. Failing since 1 week.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Performance
Created 2026-03-24 08:59:02
Last modified 2026-03-24 08:59:03 (2 weeks ago)
Latest email 2026-04-02 12:34:23 (1 week ago)
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-04-02 12:34:23 by Greg Sabino Mullane <htamfids 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-04-06 18:45:29 CFbot Patch needs rebase
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