Skip site navigation (1) Skip section navigation (2)

Re: postgresql database connection

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: chen(at)musc(dot)edu
Cc: pgsql-admin list <pgsql-admin(at)postgresql(dot)org>, mckilldj(at)musc(dot)edu
Subject: Re: postgresql database connection
Date: 2005-05-19 16:57:29
Message-ID: 1116521849.31821.91.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-admin by date

Next:From: Tomeh, HusamDate: 2005-05-19 17:10:50
Subject: Can you generate SQL by using SQL in Postgres?
Previous:From: Chuming ChenDate: 2005-05-19 16:32:56
Subject: postgresql database connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group