Thread: RE: Connection Pooling...(Repost)...please do help..

RE: Connection Pooling...(Repost)...please do help..

From
"Clark, Joel"
Date:
Yes, but the load of 200 concurrent fork()ed backends might be worse.  :)

jc

-----Original Message-----
From: Joseph Shraibman [mailto:jks@selectacast.net]
Subject: Re: [INTERFACES] Connection Pooling...(Repost)...please do
help..

"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