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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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