Re: Re: useability of apache, PHP, Postgres for real business apps - Mailing list pgsql-general

From Micah Yoder
Subject Re: Re: useability of apache, PHP, Postgres for real business apps
Date
Msg-id 01062917260805.01101@eclipse
Whole thread Raw
In response to Re: Re: useability of apache, PHP, Postgres for real business apps  (GH <grasshacker@over-yonder.net>)
Responses Re: Re: useability of apache, PHP, Postgres for real business apps
List pgsql-general
> 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


pgsql-general by date:

Previous
From: GH
Date:
Subject: Re: Re: useability of apache, PHP, Postgres for real business apps
Next
From: GH
Date:
Subject: Re: Re: useability of apache, PHP, Postgres for real business apps