Limit transaction lifetime

From: Andrei Zhidenkov <andrei(dot)zhidenkov(at)n26(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Limit transaction lifetime
Date: 2020-03-06 14:24:22
Message-ID: CAKtDQ6Bq424Rsk_AwdQ5vEXncDYzx184LnZ5R=xNiv1htAPKwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to limit a transaction lifetime in PostgreSQL? I could use
`idle_in_transaction_session_timeout` parameter but it applies only to IDLE
transactions. However, I want to rollback any transaction that executes
more than specified period of time.

--

With best regards, Andrei Zhidenkov.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-03-06 14:55:27 Re: Real application clustering in postgres.
Previous Message stan 2020-03-06 12:57:55 geting results of query in plperl