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

Re: PG on a web-server...issues..and some general questions on PG deployment

From: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
To:
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: PG on a web-server...issues..and some general questions on PG deployment
Date: 2000-12-26 13:44:29
Message-ID: 003e01c06f41$f8637980$330a0a0a@6014cwpza006 (view raw or flat)
Thread:
Lists: pgsql-interfaces
I understand what Tom is saying though.  I guess whenever someone asks about
connection pooling, it is not a yes or no answer.  You have to explain the
difference. :)

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Clark, Joel" <jclark(at)lendingtree(dot)com>
To: "'Tom Samplonius'" <tom(at)sdf(dot)com>; "Adam Lang"
<aalang(at)rutgersinsurance(dot)com>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Friday, December 22, 2000 2:33 PM
Subject: RE: [INTERFACES] PG on a web-server...issues..and some general
questions on PG deployment


> I think you get a persistent connection per httpd process, no?  If this
> really is the case, you could then limit your connection count by limiting
> the number of times that apache will spawn a new process (10 is default,
> IIRC)  This isn't exactly true pooling, but should be flexible enough to
> meet the intent...  :)
>
> Joel
>
> -----Original Message-----
> From: Tom Samplonius [mailto:tom(at)sdf(dot)com]
> Sent: Friday, December 22, 2000 11:39 AM
> To: Adam Lang
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] PG on a web-server...issues..and some general
> questions on PG deployment
>
>
>
> On Fri, 22 Dec 2000, Adam Lang wrote:
>
> > > 3. Is PHP/Postgres module capable of server side connection pooling?
> >
> > Yes.
>
>   The PHP docs are very clear to not referr to it is pooling, but
> persistant connections.  They are very different things.  PHP as a whole
> is not capable of pooling, because a separate instance of PHP runs in each
> httpd process, and those instances can not shared database connections
> between them.
>
> Tom


In response to

pgsql-interfaces by date

Next:From: Barry LindDate: 2000-12-26 20:44:30
Subject: Two minor fixes to reduce resource usage in JDBC drivers
Previous:From: Michael SimsDate: 2000-12-23 01:22:49
Subject: Re: ODBC on Solaris

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