Обсуждение: dual processors

How can I tell if postgresql is utilizing both processors of a dual
processor machine?

-Jack

If you are running on a dedicated postgres machine, run the command "top"
from the command line.  The third and fourth line should read like:

CPU0 states:  0.0% user,  5.0% system,  0.0% nice, 94.0% idle
CPU1 states:  0.1% user,  0.0% system,  0.0% nice, 99.0% idle
   (my system is idle now, but you get the idea...)

Make sure you have multiple clients interacting with the database when you
check.

-r

At 03:45 PM 7/23/01 -0500, edikos wrote:

>How can I tell if postgresql is utilizing both processors of a dual
>processor machine?
>
>-Jack
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01

Possibly.  If your OS does not support or is not currently configured for
dual processor utilization, then your machine will not use the other
CPU.  What OS/Version are you running?

-r

At 04:31 PM 7/23/01 -0500, Jack Long wrote:

>uh-oh, top looks like this for me:
>
>   3:35pm  up 43 min,  3 users,  load average: 1.02, 0.77, 0.42
>66 processes: 63 sleeping, 3 running, 0 zombie, 0 stopped
>CPU states: 22.6% user,  1.9% system,  0.0% nice, 76.0% idle
>Mem:  257532K av, 211536K used,  45996K free,  92856K shrd,  79256K buff
>Swap: 130748K av,      0K used, 130748K free                 99080K cached
>
>
>does that mean the 2nd processor is just sitting along for the ride?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01