Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group