Re: postgresql database connection

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: postgresql database connection
Дата
Msg-id 1116521849.31821.91.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на postgresql database connection  (Chuming Chen <chen@musc.edu>)
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Chuming Chen
Дата:
Сообщение: postgresql database connection
Следующее
От: Chuming Chen
Дата:
Сообщение: database connection