"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
In response to
pgsql-novice by date
|Next:||From: Fernando Fontana||Date: 2008-04-22 18:45:31|
|Subject: pgoptions syntax?|
|Previous:||From: Didier Gasser-Morlay||Date: 2008-04-22 17:18:00|
|Subject: Client connection lost; still in the task list|