[imp] high load average with postgresql

Rich Lafferty rich@horde.org
Tue, 24 Apr 2001 15:50:36 -0400


On Tue, Apr 24, 2001 at 02:31:49PM -0500, Matthew M Carroll (mmc2@csd.uwm.edu) wrote:
> Im sorry I was a bit vague 
> My machine is a dual 750

Intel, I guess?

> with 1Gig of ram. Im running suse 7.1 with 2.4.0
> I am using a mylex accelraid 170 with a 4 disk raid 5 set. at most I will
> have 150 or so users on the box averaging 3000 unique hits a day and 6000
> total hits a day. I am running horde/imp 2.2.4/1.2.4 I am running postgres
> 7.0.3

Hm. Look at horde/imp/lib/db.pgsql and horde/phplib/db_pgsql.inc -- do
they call pg_connect() or pg_pconnect()? 

If they call pg_pconnect, you will want to change that pg_connect;
pg_pconnect is broken in PHP. This is fixed in Horde and IMP's CVS
version, but I don't think it was fixed before 2.2.4 was released.

> My postmaster startup parameters are 
> 
> /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data -A 1 -B 768 -b
> /usr/bin/postgres -i -N 384 

This looks okay, I suppose -- I take it you've enabled assert checks
for some other application on that server? If not, you don't need
them.

> I guess I am wondering if the -F parameter on postgres will help that
> much?

Are you having problems with disk performance, too?

  -Rich

-- 
------------------------------ Rich Lafferty ---------------------------
 Sysadmin/Programmer, Instructional and Information Technology Services
   Concordia University, Montreal, QC                 (514) 848-7625
------------------------- rich@alcor.concordia.ca ----------------------