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