On Thu, 2005-05-19 at 11:32, Chuming Chen wrote:
> Hi, all,
> If the client didn't close the connection explicitly, how long it will
> be kept then closed by the server. Does this effect the performance?
Until the TCP/IP timeout occurs, which is usually several hours.
It only affects performance if there's a lot (like several hundred) dead
connections laying around, or if there are so many you run out of
connections and your app can't get to the database.
In response to
pgsql-admin by date
|Next:||From: Tomeh, Husam||Date: 2005-05-19 17:10:50|
|Subject: Can you generate SQL by using SQL in Postgres?|
|Previous:||From: Chuming Chen||Date: 2005-05-19 16:32:56|
|Subject: postgresql database connection|