From: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | [Re] Need help with postgresql/apache/php optimisation |
Date: | 2004-02-18 21:35:09 |
Message-ID: | 4033DA8D.5143C8E1@froggycorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thx for your quick answer too :)
Richard Huxton wrote:
>
> On Wednesday 18 February 2004 20:18, Froggy / Froggy Corp. wrote:
> > Hello,
> >
> > I asked one time for more "benchmark" soft to know where is the cpu
> > average, and read the post about optimising the postgresql.conf (and use
> > them), but i allways get a load > 1 on fire time (dunno the right name,
> > "coup de feu" in french (10h00 -> 14h00, 18h00 -> 21h00).
>
> This is the period when you get the most hits, yes?
yes
> > With different software, i dont see anything wrong (or i dont understand
> > how to use them), the problem is the memory which make some nice road
> > around 12Mo Free and 3Mo Free, but the swap dont really grow up (but
> > linux make a lot of cache).
>
> Not sure I understand you fully, but if swap isn't active you should be OK.
> See below for a good test.
Swap is active, but the size don't change a lot. (12Mb common time,
maybe 50Mb on rush time).
> There are three things to look at while testing this:
> 1. The output of "vmstat 1" - this will show memory usage, swap activity disk
> blocks in/out, cpu usage etc.
> 2. The output from "top", press "M" to sort by memory usage - that way we can
> see how much memory is being used.
> 3. How many requests are you processing at the same time?
I will use vmstat 1 tomorrow (22:24 here, so too late)
Around 4/5 postgresql thread and around 20 apache thread with top.
With mod-status from apache, i get same information, 20 requests in
process, but only some in activity.
> > If someone could help me, i need to put a new feature which will add
> > more than 2000 hit per day and im afraid about the life of the server
>
> Only 5000 hits per day? I'm sure we can get that working.
I hope :D.
Another question, i put on postgresql.conf a limited number of
postgresql max_connections, and use permanent link beetween apache and
postgresql. The problem is that a lot of apache thread is used for
sending data (gfx). Is there a way to say that some thread are only here
for php process ?
thx in advance,
regards,
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-02-18 21:53:59 | Re: [Re] Need help with postgresql/apache/php optimisation |
Previous Message | Froggy / Froggy Corp. | 2004-02-18 21:34:39 | [Re] Need help with postgresql/apache/php optimisation |