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

[Ron <ronljohnsonjr@xxxxxxxxx>]

    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.