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 AA8673A1D8A for ; Thu, 4 Nov 2004 00:28:52 +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 49276-05 for ; Thu, 4 Nov 2004 00:28:48 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 14A083A3D02 for ; Thu, 4 Nov 2004 00:28:50 +0000 (GMT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 754FC12A73D for ; Wed, 3 Nov 2004 20:28:47 -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 49306-06; Thu, 4 Nov 2004 00:28:42 +0000 (GMT) Received: from ganymede.hub.org (blk-222-46-91.eastlink.ca [24.222.46.91]) by hub.org (Postfix) with ESMTP id F08F512A73B; Wed, 3 Nov 2004 20:28:41 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id A41FF3DF31; Wed, 3 Nov 2004 20:28:45 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 908D13DF17; Wed, 3 Nov 2004 20:28:45 -0400 (AST) Date: Wed, 3 Nov 2004 20:28:45 -0400 (AST) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: Mitch Pirtle Cc: Dave Page , Alexey Borzov , Oleg Bartunov , pgsql-www@postgresql.org Subject: Re: Inadequate hosting for www.postgresql.org In-Reply-To: <330532b6041103143870f5a6d2@mail.gmail.com> Message-ID: <20041103202226.G82047@ganymede.hub.org> References: <330532b6041103143870f5a6d2@mail.gmail.com> 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/68 X-Sequence-Number: 5799 On Wed, 3 Nov 2004, Mitch Pirtle wrote: > On Wed, 3 Nov 2004 22:18:35 -0000, Dave Page wrote: >> Marc's gone for a bite to eat so I'll chip in... > > Super Dave! > >>> Marc, you say you got 15/30 set for apache, can you tell me >>> how many procs are currently running? >> >> 56 5 seconds ago: http://www.postgresql.org/server-status > > Looks okay to me. > >>> Also, is the new website using pconnect or connect? >> >> pconnect. > > Okay, hardware does not seem to be a constraint, apache/php seems > fine, mmcache is enabled; and so logically whatever is going on has to > be at the application level, either php or postgresql. Right? does anyone know of any issues with php 4.3.9? I just recently upgraded to it from 4.3.8 (ie. a week ago) ... right now, php seems to be the central issue ... I think I'm going to build an Apache/PHP4.3.8 server tomorrow, and see if that makes a difference ... I drop'd the # of processes on taht server by 1/2 this afternoon, the loadavg on the server right now is <.5 ... and alexey's site *still* takes 2.5sec to load up ... and the CPUs are running ~80% idle: last pid: 77489; load averages: 0.46, 0.35, 0.38 up 11+09:14:26 20:27:36 371 processes: 1 running, 368 sleeping, 2 zombie CPU states: 11.5% user, 0.0% nice, 6.3% system, 0.8% interrupt, 81.3% idle Mem: 1715M Active, 1388M Inact, 640M Wired, 203M Cache, 199M Buf, 10M Free Swap: 8192M Total, 3824K Used, 8188M Free So its gotta be something in mod_php itself ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664