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

From Michael Paquier
Subject Re: Terminate the idle sessions
Date
Msg-id 20200610082518.GC358163@paquier.xyz
Whole thread Raw
In response to Re: Terminate the idle sessions  (Li Japin <japinli@hotmail.com>)
Responses Re: Terminate the idle sessions  (Li Japin <japinli@hotmail.com>)
List pgsql-hackers
On Wed, Jun 10, 2020 at 05:20:36AM +0000, Li Japin wrote:
> I agree with you.  But we can also give the user to control the idle
> sessions lifetime.

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
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Speedup usages of pg_*toa() functions
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Physical replication slot advance is not persistent