Backends staying around

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Backends staying around
Дата
Msg-id 3C0CBE65.30553.53DF6C@localhost
обсуждение исходный текст
Ответы Re: Backends staying around  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Hi all,

How long are backends supposed to hang around after a query is
executed? We're running into trouble because they're not going
away - this evening there were the full default complement of 32
sitting there, and the machine was refusing any more connections.
I've increased -N to 64 and -B to 128 after reading the FAQ, but
obvously I'd prefer if they quietly died after handling requests.

We are running Postgres 7.0.2, accessed from an NT4 server via
ADO 2.5 from IIS 4 (how's that for a mouthful of acronyms...?).

Many thanks.

--Ray O'Donnell


---------------------------------------------------------
Raymond O'Donnell            http://www.iol.ie/~rod/organ
rod@iol.ie                      The Irish Pipe Organ Page
---------------------------------------------------------

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

Предыдущее
От: Luben Karavelov
Дата:
Сообщение: Large tables management question
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Backends staying around