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 AA7873A4836;
	Thu,  4 Nov 2004 04:55:20 +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 00862-09; Thu,  4 Nov 2004 04:55:19 +0000 (GMT)
Received: from hub.org (hub.org [200.46.204.220])
	by svr1.postgresql.org (Postfix) with ESMTP id A12333A484C;
	Thu,  4 Nov 2004 04:55:18 +0000 (GMT)
Received: from localhost (unknown [200.46.204.144])
	by hub.org (Postfix) with ESMTP id 87FF212A73C;
	Thu,  4 Nov 2004 00:55:18 -0400 (AST)
Received: from hub.org ([200.46.204.220])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 03103-03; Thu,  4 Nov 2004 04:55:12 +0000 (GMT)
Received: from ganymede.hub.org (blk-222-46-91.eastlink.ca [24.222.46.91])
	by hub.org (Postfix) with ESMTP id 9726912A73B;
	Thu,  4 Nov 2004 00:55:12 -0400 (AST)
Received: by ganymede.hub.org (Postfix, from userid 1000)
	id C0A263A75E; Thu,  4 Nov 2004 00:55:11 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by ganymede.hub.org (Postfix) with ESMTP id B33873A6CD;
	Thu,  4 Nov 2004 00:55:11 -0400 (AST)
Date: Thu, 4 Nov 2004 00:55:11 -0400 (AST)
From: "Marc G. Fournier" <scrappy@postgresql.org>
X-X-Sender: scrappy@ganymede.hub.org
To: Justin Clift <justin@postgresql.org>
Cc: pgsql-www@postgresql.org
Subject: Re: Inadequate hosting for www.postgresql.org
In-Reply-To: <4189B0D4.3040809@postgresql.org>
Message-ID: <20041104004958.B82047@ganymede.hub.org>
References: 
 <E7F85A1B5FF8D44C8A1AF6885BC9A0E4306FBC@ratbert.vale-housing.co.uk>
	<330532b6041103143870f5a6d2@mail.gmail.com> <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>
	<4189B0D4.3040809@postgresql.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: by amavisd-new at 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/87
X-Sequence-Number: 5818

On Thu, 4 Nov 2004, Justin Clift wrote:

> Marc G. Fournier wrote:
> <snip>
>> You might have hit it on the mark:
>
> Um, now I'm lost.  Recompiling the main PHP binary without 
> --enable-versioning was the winner?

Ya ... I think what happens is that when the main php starts up, the first 
thing it does is goes through its 'extensions' to make sure they are part 
of the same version ... *why* it would do it each and ever connection, vs 
just when apache starts up, I don't know ... but, I'm on a dial-up link at 
home and I can actually load wwwdevel.postgresql.org now, where before I 
had enough time to go to the kitchen for a drink waiting for it to load 
...

But, I also don't believe it was *just* that option ... the database was 
slow, due to the need for the vacuum full, which was apparent with the 
load times on the current site ...

But, after upgrading and restarting apache on all the VMs, with the change 
to PHP, even the servers loadavg are all back down to 'normal' ...

What I suspect is that before the PHP maintainer "split up" teh extensions 
to seperate ports each, instead of one built binary, he didn't have the 
versioning enabled ... it was only because of the splits that he added it, 
so it never affected us before ...

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