Date: Wed, 3 Nov 2004 08:04:27 -0400 (AST)
From: "Marc G. Fournier" <scrappy@postgresql.org>
To: Alexey Borzov <borz_off@cs.msu.su>
Cc: Oleg Bartunov <oleg@sai.msu.su>,
	Dave Page <dpage@vale-housing.co.uk>, pgsql-www@postgresql.org
Subject: Re: Inadequate hosting for www.postgresql.org
In-Reply-To: <4188B48C.9050103@cs.msu.su>
Message-ID: <20041103074944.W82047@ganymede.hub.org>
References: 
 <E7F85A1B5FF8D44C8A1AF6885BC9A0E4306F1E@ratbert.vale-housing.co.uk>
	<41878616.70705@cs.msu.su> <20041102114746.R33702@ganymede.hub.org>
	<4187E864.5000703@cs.msu.su> <20041102163552.X82047@ganymede.hub.org>
	<20041102164614.I82047@ganymede.hub.org>
	<Pine.GSO.4.61.0411030400030.24492@ra.sai.msu.su>
	<4188B48C.9050103@cs.msu.su>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Wed, 3 Nov 2004, Alexey Borzov wrote:

> Hi,
>
> Oleg Bartunov wrote:
>> It shows, that possible problem could be news.rss, events.rss.
>
> That's because these pages are dynamic, too. But I think it's an error in 
> webperf that it considers them part of index page.
>
>>     This is a classical 3 servers setup and it described in many books and
>>     success stories.
>
> Your suggestion is nice and all, but right now we are discussing the fact 
> that we don't even have *one* dedicated server. Only a shared account on 
> substandard  hardware, incapable of running PHP scripts. :(

This has yet to be proven, IMHO ... Dave has already stated that the old 
build scripts aren't nearly as slow as yours, and it was having to deal 
with PHP as well ...

Your first "complaint" was that it wasn't loading the files fast enough 
... so, I enabled mmcache on that server with shared memory use only, so 
that it doesn't use disk except for the first load ... the build is still 
atrociously slow ... the servers are all setup so that shared memory is 
locked into physical RAM, so now what?  The RAM is too slow?

If anyone wants to look at the PHP settings on that server, check out 
http://www.postgresql.org/phpinfo.php ... is there something that should 
be different on compile?  or something that is turned on that might cause 
a slowdown?  I'm using pretty much default FreeBSD ports options, in so 
far as build and php.ini is concerned ... maybe there is something in 
there that should be changed to optimize better?  The server itself is 
doing neglible swapping (<6M) and unless I've been reading top wrong all 
my life (which is definitely a possibility) its reporting 1G of 'Inact' 
RAM, which I believe means that available for processes ... ?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664