> On 23 Mar 2026, at 16:47, Nikhil Chawla <[email protected]> wrote:
>
> idle_in_transaction_session_timeout, idle_session_timeout, statement_timeout,
> but no equivalent for prepared transactions
During implementation of the transaction_timeout we briefly considered prepared
xacts, but decided that it's a footgun.
DBA can easily do the same with a cron job, but in case of prepared
transactions monitoring is crucial. Prepared xacts are used to coordinate
commit in many durable systems and orphan prepared xact is evidence of serious
malfunction.
Silent rollback in any scenario I can imagine is a disaster.
Best regards, Andrey Borodin.
