Re: Re: useability of apache, PHP, Postgres for real business apps
От | Micah Yoder |
---|---|
Тема | Re: Re: useability of apache, PHP, Postgres for real business apps |
Дата | |
Msg-id | 01062917260805.01101@eclipse обсуждение исходный текст |
Ответ на | Re: Re: useability of apache, PHP, Postgres for real business apps (GH <grasshacker@over-yonder.net>) |
Ответы |
Re: Re: useability of apache, PHP, Postgres for real business apps
|
Список | 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 по дате отправления: