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

-Jack

---------------------------(end of broadcast)---------------------------



Sat, 10 Jan 2004 04:57:59 GMT
 dual processors

--=======6A4A480E=======
Content-Type: text/plain; charset=us-ascii; format=flowed; x-avg-checked=avg-ok-452B1F81

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


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

>-Jack

>---------------------------(end of broadcast)---------------------------

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

--=======6A4A480E=======
Content-Type: text/plain; charset=us-ascii; x-avg-checked=avg-ok-452B1F81

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

--=======6A4A480E=======
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
MIME-Version: 1.0

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

--=======6A4A480E=======--



Sat, 10 Jan 2004 05:32:06 GMT
 dual processors
--=======26F3BE9=======
Content-Type: text/plain; charset=us-ascii; format=flowed; x-avg-checked=avg-ok-452B1F81

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


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

--=======26F3BE9=======
Content-Type: text/plain; charset=us-ascii; x-avg-checked=avg-ok-452B1F81

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

--=======26F3BE9=======
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
MIME-Version: 1.0

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--=======26F3BE9=======--



Sat, 10 Jan 2004 06:05:09 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Can you allocate one processor in a dual processor system for sql 7

2. Dual Processor v Single Processor

3. Single processor SQL 2000 on dual processor server

4. dual processor /License and number of processors

5. Single processor or dual processor license

6. sql 7 slower on dual processors

7. Dual-processor a waste with SQL-Server 6.5?

8. Bulkcopy hangs on dual processor machine

9. dual processor

10. SQL2000 on a dual processor server.

11. SQL7 Hardware Q - single vs dual processors

12. SQL 7 & dual-processor


 
Powered by phpBB® Forum Software