> On 23 Mar 2026, at 16:47, Nikhil Chawla <chawlanikhil24(at)gmail(dot)com> 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.