postgresql database connection

Поиск
Список
Период
Сортировка
Искать

postgresql database connection

От:
Chuming Chen <chen@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

Re: postgresql database connection

От:
Scott Marlowe <smarlowe@g2switchworks.com>
Дата:
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.
FAQ