pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql database connection
2+ messages / 2 participants
[nested] [flat]
* postgresql database connection
@ 2005-05-19 16:32 Chuming Chen <chen@musc.edu>
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:57 Scott Marlowe <smarlowe@g2switchworks.com>
parent: Chuming Chen <chen@musc.edu>
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