PG 8.1 on Dual XEON with FreeBSD 6.0

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(dot)lang(at)attiksystem(dot)ch
Skype: philippe.lang