Re: Postres.exe Processes Hang - Mailing list pgsql-general

From Kim Robinson
Subject Re: Postres.exe Processes Hang
Date
Msg-id F9A3F63DFFDF5043AE783A7818A22AAB9337F5@swhexprod2.hydrotasmania.com.au
Whole thread Raw
In response to Re: Postres.exe Processes Hang  ("Francisco Figueiredo Jr." <francisco@npgsql.org>)
Responses Re: Postres.exe Processes Hang  ("Francisco Figueiredo Jr." <francisco@npgsql.org>)
List pgsql-general
Great thanks all.
Can you give me any indication of the performance implications of
setting pooling=false?

-----Original Message-----
From: francisco.figueiredo.jr@gmail.com
[mailto:francisco.figueiredo.jr@gmail.com] On Behalf Of Francisco
Figueiredo Jr.
Sent: Tuesday, 19 August 2008 3:48 AM
To: Magnus Hagander
Cc: Kim Robinson; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postres.exe Processes Hang

On 8/18/08, Magnus Hagander

Hi, all!
As Magnus said, this is caused by the fact Npgsql does connection pool
by default.
You can change that by passing pooling=false in your connection string.

You can get more info at
manual.npgsql.org

I hope it helps


<magnus@hagander.net> wrote:
> Kim Robinson wrote:
>>
>>
>> Hi,
>>
>> I am using the npgsql postgres data adaptor in a C# ASP.NET
application.
>> Each time the site establishes a new connection to the database a
>> postgres.exe process is started. For some reason this process is not
>> removed when the connection is closed.
>>
>> Any help would be greatly appreciated.
>
> Are you by any chance using some connection pooling that keeps it
alive?
> I don't remember what the default is in npgsql, but a lot of
frameworks
> have connection pooling enabled by default.
>
> //Magnus
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


--
Regards,

Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org


--
Regards,

Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: What's size of your PostgreSQL Database?
Next
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Postres.exe Processes Hang