Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin
От
Ron
Тема
Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin
Дата
Msg-id
9ff830d1-1432-bd07-46f0-5975ef88271c@gmail.com
Ответ на
RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin (Dirschel, Steve)
Список
Дерево обсуждения
DBeaver session populating pg_stat_activity.backend_xmin "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: DBeaver session populating pg_stat_activity.backend_xmin Thomas Kellerer <shammat@gmx.net>
RE: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Re: [EXT] Re: DBeaver session populating pg_stat_activity.backend_xmin Ron <ronljohnsonjr@gmail.com>
Re: [EXT] DBeaver session populating pg_stat_activity.backend_xmin Christophe Pettus <xof@thebuild.com>
RE: [EXT] DBeaver session populating pg_stat_activity.backend_xmin "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
On 1/25/23 16:21, Dirschel, Steve wrote:
[snip]
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
[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.
Born in Arizona, moved to Babylonia.
В списке pgsql-general по дате отправления
От: Dirschel, Steve
Дата:
От: Christophe Pettus
Дата:
