Re: Persistent Connections - Mailing list pgsql-performance

From Randolf Richardson
Subject Re: Persistent Connections
Date
Msg-id Xns947BE3A61D0B8rr8xca@200.46.204.72
Whole thread Raw
In response to Persistent Connections  (postgres@countup.de)
Responses Re: Persistent Connections
List pgsql-performance
"nicky@chuckie.co.uk (Nick Barr)" stated in
comp.databases.postgresql.performance:

> postgres@countup.de wrote:
[sNip]
>> Sorry I m a little bit confused about the persistent thing!!
>> Is it smart to use persistent connections at all if i expect 100K
>> Users to hit the script in an hour and the script calls up to 10-15 pg
>> functions?
>> I have at the mom one function but the server needs 500 ms, its a
>> little bit too much i think, and it crashed when i had 20K users
>
> Use the persistent connection but make sure the parameters in
> postgresql.conf match up with the Apache config. The specific settings
> are MaxClients in httpd.conf and max_connections in postgresql.conf.
> Make sure that max_connections is at least as big as MaxClients for
> every database that your PHP scripts connect to.

        Do you happen to have (or know where to get) some sample configuration
files for Apache 2 and PostgreSQL for this?  The documentation I've found
so far is pretty sparse, and sample files would be very helpful.

        THanks in advance.

--
Randolf Richardson - rr@8x.ca
Vancouver, British Columbia, Canada

"We are anti-spammers.  You will confirm
subscriptions.  Resistance is futile."

Please do not eMail me directly when responding
to my postings in the newsgroups.

pgsql-performance by date:

Previous
From: "Arnau Rebassa i Villalonga"
Date:
Subject: Queries with timestamp, 2
Next
From: Shridhar Daithankar
Date:
Subject: Re: Queries with timestamp II