Re: Inadequate hosting for www.postgresql.org - Mailing list pgsql-www

From Marc G. Fournier
Subject Re: Inadequate hosting for www.postgresql.org
Date
Msg-id 20041103202226.G82047@ganymede.hub.org
Whole thread Raw
In response to Re: Inadequate hosting for www.postgresql.org  (Mitch Pirtle <mitch.pirtle@gmail.com>)
Responses Re: Inadequate hosting for www.postgresql.org  (Justin Clift <justin@postgresql.org>)
List pgsql-www
On Wed, 3 Nov 2004, Mitch Pirtle wrote:

> On Wed, 3 Nov 2004 22:18:35 -0000, Dave Page <dpage@vale-housing.co.uk> 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

pgsql-www by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: pg_autovacuum is nice ... but ...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Inadequate hosting for www.postgresql.org