Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin

On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
>>> The problem is users will connect using DBeaver and their sessions
>>> will sit idle.
>> Idle is not a problem, "idle in transaction" is.
>  From my perspective "idle in transaction" isn't necessarily a problem (although I don't like seeing sessions sitting like that for a long time).

Well, it is, since you /are/ sitting in an open transaction.

This fixes it: idle_in_transaction_session_timeout
https://www.postgresql.org/docs/9.6/runtime-config-client.html

-- 
Born in Arizona, moved to Babylonia.