[imp] high load average with postgresql

[Matthew M Carroll]

On Tue, 24 Apr 2001, Rich Lafferty wrote:

> 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?

Yeah Im running Intel :]

> 
> > 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()? 

horde/imp/lib/db.pgsql was using pg_pconnect I have changed it,
phplib/db_pgsql.inc  was using the right function. 

> 
> 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 was wondering what the -A 1 was I cant find it in the man for
postmaster. What exactly does that do? As you can tell I am new to
postgres.
 
> > I guess I am wondering if the -F parameter on postgres will help that
> > much?
> 
> Are you having problems with disk performance, too?

Now that you mention it I am having problem with disk at times I have had
a load avg of 30 with 70% idle time on both cpu's.

If I were to use the -F option would I put it after the /usr/bin/postgres
so my postmaster.opts would look like this? I tried to put the -F in
rc.config with the rest of postmaster's startup stuff but it failed.

/usr/bin/postmaster
-p 5432
-D /var/lib/pgsql/data
-A 1
-B 768
-b /usr/bin/postgres -F
-i
-N 384

Thanks again for all the help,

> 
>   -Rich
> 
> -- 
> ------------------------------ Rich Lafferty ---------------------------
>  Sysadmin/Programmer, Instructional and Information Technology Services
>    Concordia University, Montreal, QC                 (514) 848-7625
> ------------------------- rich@alcor.concordia.ca ----------------------
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
> 
> 


Matthew M Carroll
mmc2@csd.uwm.edu