Re: postgresql database connection - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: postgresql database connection
Date
Msg-id 1116521849.31821.91.camel@state.g2switchworks.com
Whole thread Raw
In response to postgresql database connection  (Chuming Chen <chen@musc.edu>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Chuming Chen
Date:
Subject: postgresql database connection
Next
From: Chuming Chen
Date:
Subject: database connection