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

Indeed, here is an excerpt from my original post with the context intact:

-> I haven't found PG to have much connection overhead, why would
open/closing
-> a connection-per-query require server side connection pooling? You might
-> try having your application acquire a connection on-demand and then
having a
-> timeout mechanism that discards the connection after a certain amount of
-> idle time. That [way] if you have to fire off hundreds of small queries
you don't
-> encounter connection overhead. If the machine is idle, it disconnects
and
-> the server doesn't get loaded down with tons of idle backends.

This *would* be my definition of sensible caching. It is the best of both
worlds, superceded only by an intelligent middle tier.

jc

-----Original Message-----
From: Joseph Shraibman [mailto:jks(at)selectacast(dot)net]
Sent: Tuesday, December 19, 2000 5:30 PM
To: Clark, Joel
Subject: Re: [INTERFACES] Connection Pooling...(Repost)...please do
help..

With sensible caching you won't have too many more open than you need.

"Clark, Joel" wrote:
>
> Yes, but the load of 200 concurrent fork()ed backends might be worse. :)
>
> jc
>
> -----Original Message-----
> From: Joseph Shraibman [mailto:jks(at)selectacast(dot)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(at)selectacast(dot)net
> Increase signal to noise ratio. http://www.targabot.com

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com