Re: Connection Pooling...(Repost)...please do help.. - Mailing list pgsql-interfaces

From Joseph Shraibman
Subject Re: Connection Pooling...(Repost)...please do help..
Date
Msg-id 3A3EB781.80186971@selectacast.net
Whole thread Raw
In response to RE: Connection Pooling...(Repost)...please do help..  ("Clark, Joel" <jclark@lendingtree.com>)
List pgsql-interfaces
"Clark, Joel" wrote:
> 
> I haven't found PG to have much connection overhead, why would open/closing
> a connection-per-query require server side connection pooling? 

Each connection causes the backend to fork.  With a heavy load you'll
feel the overhead of creating and closing so many connections.


-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com


pgsql-interfaces by date:

Previous
From: Stephen Davies
Date:
Subject: re:ODBC handling of bools?
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: Re: Plperl make fails with Error1 at plperl.o (7.0.3)