From: | Randolf Richardson <rr(at)8x(dot)ca> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Persistent Connections |
Date: | 2004-01-26 06:35:34 |
Message-ID: | Xns947BE3A61D0B8rr8xca@200.46.204.72 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
"nicky(at)chuckie(dot)co(dot)uk (Nick Barr)" stated in
comp.databases.postgresql.performance:
> postgres(at)countup(dot)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(at)8x(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Arnau | 2004-01-26 14:12:38 | Queries with timestamp II |
Previous Message | Stephan Szabo | 2004-01-25 21:14:05 | Re: query slows under load |