Re: [AOLSERVER] Performance problems with large installation

[patrick o'leary]

One thing to consider is that you simply may have 1 or more slow queries running in your DB, I believe from the postgres website you can use select * from pg_stat_activity To determine the process list of queries running. If you have ns_section ns/db/pool/pool1 (2/3....) ns_param Verbose on It will also show you the rate at which queries are being sent to your DB. Keep an eye open on you /var/log/messages for anything weird. P Nathan Folkman wrote: The included stats interface should help: ns_section "ns/server/stats"     ns_param enabled 1     ns_param url "/_stats"     ns_param user "aolserver"     ns_param password "stats" Then take a look at the "Process" and "Threads" sections. - n On Feb 3, 2006, at 12:44 PM, Nima wrote: Is there any way to find out how many concurrent users I currently  have? -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to  <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the  Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank. -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.