X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 429833A3C11; Thu, 4 Nov 2004 01:00:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57765-03; Thu, 4 Nov 2004 01:00:22 +0000 (GMT) Received: from tetra.ehpg.net (tetra.ehpg.net [216.218.206.34]) by svr1.postgresql.org (Postfix) with ESMTP id D18613A46E6; Thu, 4 Nov 2004 01:00:23 +0000 (GMT) Received: from [66.63.169.28] (helo=[66.63.169.28]) by tetra.ehpg.net with asmtp (Exim 4.41) id 1CPVzB-0002hH-HK; Wed, 03 Nov 2004 17:00:22 -0800 Message-ID: <41897F17.4020503@ehpg.net> Date: Wed, 03 Nov 2004 17:00:07 -0800 From: "Gavin M. Roy" User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Mitch Pirtle Cc: "Marc G. Fournier" , Dave Page , Alexey Borzov , Oleg Bartunov , pgsql-www@postgresql.org Subject: Re: Inadequate hosting for www.postgresql.org References: <330532b6041103143870f5a6d2@mail.gmail.com> <41895FF2.10709@ehpg.net> <20041103202855.Y82047@ganymede.hub.org> <330532b6041103164743857939@mail.gmail.com> In-Reply-To: <330532b6041103164743857939@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.7 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL_SPAM, RCVD_IN_SBL X-Spam-Level: * X-Archive-Number: 200411/72 X-Sequence-Number: 5803 If it would help, I could give Alexey a shell and pgsql database to test on my server with and see if he sees any significant differences. Gavin Mitch Pirtle wrote: >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 > >