Re: idle processes

Поиск
Список
Период
Сортировка
От Robert Paulsen
Тема Re: idle processes
Дата
Msg-id 200408142343.39360.robert@paulsenonline.net
обсуждение исходный текст
Ответ на Re: idle processes  (CSN <cool_screen_name90001@yahoo.com>)
Список pgsql-general
On Saturday 14 August 2004 11:17 pm, CSN wrote:
> I'm using regular pg_connect's. The processes
> eventually went away - was just wondering why they'd
> stick around.
>

Well, unless I misunderstand, when a script ends the connection should go away
and I think that means the postgres process supporting it should also go
away. Is it possible your script is not ending or is in some kind of loop?

I asked about persistent connections because I believe they are supposed to
hang around after the script ends and because I noticed the behavior you
mentioned ("extraneous" postgres processes) while experimenting with them.
With regular non-persistent connections I don't see those long-lived
processes.

(Aside from the point of your question, it seems to me persistent are somewhat
useless since you can't close them when you are done with them.)

--
Robert C. Paulsen, Jr.
robert@paulsenonline.net

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

Предыдущее
От: CSN
Дата:
Сообщение: Re: idle processes
Следующее
От: Paramveer.Singh@trilogy.com
Дата:
Сообщение: exception handling support in pgSQL