RE: [EXT] DBeaver session populating pg_stat_activity.backend_xmin

2023-01-31 Thread Dirschel, Steve
Cc: Thomas Kellerer ; pgsql-general@lists.postgresql.org > Subject: Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin > > On Jan 25, 2023, at 14:21, Dirschel, Steve > > wrote: > > From my perspective "idle in transaction" isn't necessarily a pr

Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin

2023-01-25 Thread Christophe Pettus
> On Jan 25, 2023, at 14:21, Dirschel, Steve > wrote: > 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). > The problem is when pg_stat_activity.backend_xmin is populated- that can > prevent a