Thread: 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