Re: idle processes - Mailing list pgsql-general

From Robert Paulsen
Subject Re: idle processes
Date
Msg-id 200408142343.39360.robert@paulsenonline.net
Whole thread Raw
In response to Re: idle processes  (CSN <cool_screen_name90001@yahoo.com>)
List 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 by date:

Previous
From: CSN
Date:
Subject: Re: idle processes
Next
From: Paramveer.Singh@trilogy.com
Date:
Subject: exception handling support in pgSQL