Re: Re: useability of apache, PHP, Postgres for real business apps

> Not exactly.
> Pretend the following:
> You have 3 database users (usernames) using persistent connections.
> In the simplest case, you need 3 PostgreSQL backends to support one each
> of those users. That means you need 3 backends per httpd process.
> 10 concurrent httpd clients => 30 PostgreSQL backends.

Well I only need to connect from one database user -- nobody. But my
pg_pconnect string specifies the database to use -- pg_pconnect("dbname=otg
host=localhost port=5432");

And there are (or will be) other databases on the system, but all will
probably connect from nobody. Does pconnect use the same connection for
different databases if it is from the same user?

> Yep, ouch. In an extreme case, you might want to check out AOLServer for
> its pooling stuff. Technically, you only need enough ram to support the

Might not be a bad idea. Does it support PHP and virtual hosts and all that
as well as Apache?

--
Like to travel? http://TravTalk.org
Micah Yoder Internet Development http://yoderdev.com