SEO

#1 (**permalink**) 04-10-2008, 12:51 AM

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?

Thanks,

--
Chuming Chen
System Administrator
NHLBI Proteomics Center
Medical University of South Carolina
135 Cannon Street, Suite 303
Charleston SC 29425
Tel: 843-792-1555 (O)
Fax: 843-876-1126

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#2 (**permalink**) 04-10-2008, 12:51 AM

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

postgresql database connection