Because longer idle transactions are used by a bunch of processes, but it's a certain group of users I don't want having idle transactions, so here we are...
On Wed, Apr 19, 2023 at 1:11 PM Thomas Kellerer <shammat@xxxxxxx> wrote:
Wells Oliver schrieb am 19.04.2023 um 21:41:
> I usually prefer pg_cancel_backend because it seems.. nicer, but
> lately I've had a troublesome user who leaves transactions open and
> I've scripted up a call to pg_terminate_backend after 60 minutes in
> an idle transaction. It works well.
Why don't you use the idle_in_transaction_session_timeout to do this automatically?
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
