PG 8.1 on Dual XEON with FreeBSD 6.0 - Mailing list pgsql-general

From Philippe Lang
Subject PG 8.1 on Dual XEON with FreeBSD 6.0
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F4218CC50@poweredge.attiksystem.ch
Whole thread Raw
Responses Re: PG 8.1 on Dual XEON with FreeBSD 6.0
List pgsql-general
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@attiksystem.ch
Skype: philippe.lang

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rebranding PostgreSQL
Next
From: Csaba Nagy
Date:
Subject: locked backend