pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgresql database connection
2+ messages / 2 participants
[nested] [flat]

* postgresql database connection
@ 2005-05-19 16:32 Chuming Chen <chen@musc.edu>
  2005-05-19 16:57 ` Re: postgresql database connection Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chuming Chen @ 2005-05-19 16:32 UTC (permalink / raw)
  To: pgsql-admin; +Cc: mckilldj@musc.edu

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: postgresql database connection
  2005-05-19 16:32 postgresql database connection Chuming Chen <chen@musc.edu>
@ 2005-05-19 16:57 ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2005-05-19 16:57 UTC (permalink / raw)
  To: chen@musc.edu; +Cc: pgsql-admin; mckilldj@musc.edu

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-19 16:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-19 16:32 postgresql database connection Chuming Chen <chen@musc.edu>
2005-05-19 16:57 ` Scott Marlowe <smarlowe@g2switchworks.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox