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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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