Hi Dan, Well, I can't answer for all of your daemons but here is how to do it for PostgreSQL. In the init script that starts it try adding the following two arguments. -N 0-1024 (number of backends) (for more then that you need to recompile, default is 32) -B double whatever you put for the -N above (This is the number of shared buffers) You may want to ramp up slowly as going too far with this could really put a load on quickly. There are also other tuning methods around, and most can be found from google or dejanews searches. Have fun, -- _________________________________________________________________ Brian Ashe CTO [EMAIL PROTECTED] Dee-Web Software Services, LLC. http://www.dee-web.com/ ----------------------------------------------------------------- You don't have to swim faster than the shark... You just have to swim faster than the people you're with. Wednesday, September 13, 2000, 9:02:56 PM, you wrote: DB> How do I set maximum number of concurrent processes for users that run DB> daemons, such as postgreSQL (under postgres user), or interchange, or mysql, DB> or anything for that matter. limits.conf edits by themselves don't work. DB> I found in performance testing that my system would lock up under a light DB> load (400 concurrent HTTP GET's or so) because "Could not Fork" errors. And DB> `top` showed I never got much more than 510 processes running. DB> I've been successful in creating a user (test), then setting it's DB> performance limits (/etc/security/limits.conf), and ALSO setting DB> /etc/pam.d/login with a "session required DB> /lib/security/pam_limits.so". But when I perform the same steps for DB> postgres, (I even tried making a /etc/pam.d/postgresql file) it doesn't have DB> any effect. DB> I've tried all the docs that I know, can anyone give me the magic DB> combination to increase my 256 processes-per-user dilemma that applies to DB> daemons? DB> I know that Oracle avoids the problem all together and just has you run it's DB> osh program (which is suid root) and that sets ulimits. DB> I'm using rh62 on a dual Zeon, raid0/1 on 6 ultra160 cheetahs, and 1gb ram. DB> Thanks for any help, DB> Dan Browning DB> Network & Database Administrator DB> Cyclone Computer Systems DB> _______________________________________________ DB> Redhat-list mailing list DB> [EMAIL PROTECTED] DB> https://listman.redhat.com/mailman/listinfo/redhat-list _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
