Resucing the tcp_keepalive to 900 seconds did help immensely
thanks for the advice Tom
>You're right, this morning most connections had been freed.
>I have seen that the tcp_keepalive
> is 7200 second, I'll shorten that to see.
On Tue, Apr 22, 2008 at 7:29 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Didier Gasser-Morlay" <didiergm(at)gmail(dot)com> writes:
> > So my question is what makes PostgreSQL realise that a connection is
> > dead ? when will it drop it and free the connection ?
> It'll drop it when the kernel tells it the connection is dead.
> Standard TCP timeouts are measured in hours, though. You might
> be able to get a shorter timeout to be applied by fooling with
> the "keepalive" parameters, if those can be adjusted on your platform.
> regards, tom lane
pgsql-novice by date
|Next:||From: Didier Gasser-Morlay||Date: 2008-04-24 09:18:19|
|Subject: Limiting the number of connections for one user|
|Previous:||From: Didier Gasser-Morlay||Date: 2008-04-24 09:08:12|
|Subject: Changing a trigger function|