DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=DJBtxbVHGCnqL7S4jdyRjYkziMABHnZS9ksxUa3FNMAA9J8yIKYy3UArIYzCzsozMZwDOZzqGF3Va2kI088dr6huvofyBZIEYd3saGy950sxDKVZD16F2hOIdLRRxlA5BjaUihrTMSf0SBhhTF2rhNWOLYzr7YXHPxM70sFZr2w=
Message-ID: <330532b6041103164743857939@mail.gmail.com>
Date: Wed, 3 Nov 2004 19:47:15 -0500
From: Mitch Pirtle <mitch.pirtle@gmail.com>
Reply-To: Mitch Pirtle <mitch.pirtle@gmail.com>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Subject: Re: Inadequate hosting for www.postgresql.org
Cc: "Gavin M. Roy" <gmr@ehpg.net>, Dave Page <dpage@vale-housing.co.uk>,
	Alexey Borzov <borz_off@cs.msu.su>, Oleg Bartunov <oleg@sai.msu.su>,
	pgsql-www@postgresql.org
In-Reply-To: <20041103202855.Y82047@ganymede.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: 
 <E7F85A1B5FF8D44C8A1AF6885BC9A0E4306FBC@ratbert.vale-housing.co.uk>
	<330532b6041103143870f5a6d2@mail.gmail.com> <41895FF2.10709@ehpg.net>
	<20041103202855.Y82047@ganymede.hub.org>

php 4.3.9 has no issues that I am aware of, and I am running 20
different sites on it.  Some basic, some complex.  Faster mmcache
performance with shm turned off would tell me that something was wrong
however.  :-/

> I even grab'd a recursive directory script off of php.net, so taht I ran
> it thorugh php ... did a stat on all 28k files to get mtime (again, not
> reading in the whole file, only the meta data), but I was getting
> ~200files/sec off of that ...
> 
> So, the only thing I can think of is a problem with Alexey's code, which
> he swears is impossible ... or a problem with mod_php4.3.9 itself ...
> 
> I even drop'd the # of processes on that server by 1/2 this afternoon, and
> there is no noticeable improvement to Alexey's code ...

Hmm, is it possible to create a test script with a test schema, say
four or five tables that is portable?  That way we could run it on
several machines to get a comparison.  I have a couple SMP and
uniprocessor machines, all with 4.3.9 that I would happily run
benchmarks on.

-- Mitch