Postgres Pro
Downloads
Home   >   mailing lists

Re: Terminate the idle sessions - Mailing list pgsql-hackers

From Li Japin
Subject Re: Terminate the idle sessions
Date
Msg-id AFE3C678-9687-41AA-8BD7-D00A48C65267@hotmail.com
Whole thread Raw
In response to Re: Terminate the idle sessions  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Terminate the idle sessions
List pgsql-hackers
Tree view


On Jun 10, 2020, at 4:25 PM, Michael Paquier <michael@paquier.xyz> wrote:

Idle sessions staying around can be a problem in the long run as they
impact snapshot building.  You could for example use a background
worker to do this work, like that:
https://github.com/michaelpq/pg_plugins/tree/master/kill_idle

Why not implement it in the core of Postgres? Are there any disadvantages of
implementing it in the core of Postgres?

Japin Li

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Atomic operations within spinlocks
Next
From: Andrew Dunstan
Date:
Subject: Re: Recording test runtimes with the buildfarm