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 2E40E3A47AF
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu,  4 Nov 2004 03:50:40 +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 85684-02
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Thu,  4 Nov 2004 03:50:27 +0000 (GMT)
Received: from mproxy.gmail.com (mproxy.gmail.com [216.239.56.247])
	by svr1.postgresql.org (Postfix) with ESMTP id CA2C33A4794
	for <pgsql-www@postgresql.org>; Thu,  4 Nov 2004 03:50:28 +0000 (GMT)
Received: by mproxy.gmail.com with SMTP id w67so9822cwb
	for <pgsql-www@postgresql.org>; Wed, 03 Nov 2004 19:50:28 -0800 (PST)
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=WPPgHKzGdiX3XGy6xTYg0kBDgODX5dzUjH8enw4ibHgZAw6FEdVw1/t75VanBMQi8QP2uktg1T3UyR8l70Rw2czLR0rZ7beqcN7DUsp4AzGmo45jqolY6DdrZ6iWr1tCPtxuXrBLV29DzWIMt75j3h2BqxclZ01tyyKPU1yzdt4=
Received: by 10.11.117.43 with SMTP id p43mr89907cwc;
	Wed, 03 Nov 2004 19:50:28 -0800 (PST)
Received: by 10.11.119.69 with HTTP; Wed, 3 Nov 2004 19:50:28 -0800 (PST)
Message-ID: <330532b604110319506abcbccc@mail.gmail.com>
Date: Wed, 3 Nov 2004 22:50:28 -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: <20041103234219.M82047@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>
	<41895FF2.10709@ehpg.net> <20041103202855.Y82047@ganymede.hub.org>
	<330532b6041103164743857939@mail.gmail.com>
	<20041103205945.R82047@ganymede.hub.org>
	<330532b604110317243f079b55@mail.gmail.com>
	<20041103215500.O82047@ganymede.hub.org>
	<20041103221933.F82047@ganymede.hub.org>
	<330532b60411031853570beed7@mail.gmail.com>
	<20041103234219.M82047@ganymede.hub.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/85
X-Sequence-Number: 5816

On Wed, 3 Nov 2004 23:43:24 -0400 (AST), Marc G. Fournier
<scrappy@postgresql.org> wrote:
> Nope, looks like the --enable version only matters in the main php binary,
> as it hasn't improved load times ... but, using lynx on teh server itself,
> its definitely not hanging on load anymore like it was before ...

Ok then.  Looks to me like we've dealt with hardware, i/o, apache,
php, and the database ;-)  I mean, if we can't tune postgresql than it
should be impossible LOL

At this point it would be good to get some profiling on one of the
slower pages - being able to time the database tasks, template
rendering and logical computation would go a long way to seeing just
where the tuning steps could be taken.

So we have shown that other PHP scripts on this server are quick, and
that the focus of the tuning is really pointed at the new website,
right?

-- Mitch