Search Postgresql Archives

PG 8.1 on Dual XEON with FreeBSD 6.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

The FreeBSD 6.0 SMP Kernel recognizes my two XEONS as 4 CPUs.

A single postgresql query, as I could see in the top utility, can use a
maximum of 25% of CPU time, since it runs on one single virtual CPU,
which means for me "half of a XEON". Is that correct?

If yes, is there a way to change that, and accelerate long queries
(which are all CPU-bound) in giving them more processing time, like a
full XEON? Both XEONS? Should I disable Hyperthreading for that?

Thanks,

----------------------------------
Philippe Lang
Attik System
rte de la Fonderie 2
1700 Fribourg
Switzerland
http://www.attiksystem.ch

Tel:   +41 (26) 422 13 75 
Fax:   +41 (26) 422 13 76
GSM:   +41 (79) 351 49 94
Email: philippe.lang@xxxxxxxxxxxxxx
Skype: philippe.lang

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux