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 sitti
>> When I connect to the database through DBeaver with those 2 default
>> settings changed and find that session in pg_stat_activity column
>> xact_start is populated along with backend_xmin. Those get populated
>> just by logging in.
>As you found out in the log, the driver runs DbEaver run m
Dirschel, Steve schrieb am 25.01.2023 um 20:36:
When I connect to the database through DBeaver with those 2 default
settings changed and find that session in pg_stat_activity column
xact_start is populated along with backend_xmin. Those get
populated just by logging in.
As you found out in the
