PG 8.1 on Dual XEON with FreeBSD 6.0

Поиск
Список
Период
Сортировка
От Philippe Lang
Тема PG 8.1 on Dual XEON with FreeBSD 6.0
Дата
Msg-id 6C0CF58A187DA5479245E0830AF84F4218CC50@poweredge.attiksystem.ch
обсуждение исходный текст
Ответы Re: PG 8.1 on Dual XEON with FreeBSD 6.0  (Daniel Kalchev <daniel@digsys.bg>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Rebranding PostgreSQL
Следующее
От: Csaba Nagy
Дата:
Сообщение: locked backend