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

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "Clark, Joel" <jclark(at)lendingtree(dot)com>
Cc: "'sk(at)pobox(dot)com'" <sk(at)pobox(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Connection Pooling...(Repost)...please do help..
Date: 2000-12-19 01:18:57
Message-ID: 3A3EB781.80186971@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2000-12-19 06:58:30 RE: Plperl make fails with Error1 at plperl.o (7.0.3)
Previous Message Stephen Davies 2000-12-18 23:21:24 re:ODBC handling of bools?