Re: how much mem to give postgres?

Поиск
Список
Период
Сортировка
От Matt Clark
Тема Re: how much mem to give postgres?
Дата
Msg-id 41767104.10702@ymogen.net
обсуждение исходный текст
Ответ на Re: how much mem to give postgres?  (Josh Close <narshe@gmail.com>)
Ответы Re: how much mem to give postgres?  (Steve Atkins <steve@blighty.com>)
Список pgsql-performance
>How would I turn that off? In the kernel config? Not too familiar with
>that. I have a 2 proc xeon with 4 gigs of mem on the way for postgres,
>so I hope HT isn't a problem. If HT is turned off, does it just not
>use the other "half" of the processor? Or does the processor just work
>as one unit?
>
>
You turn it off in the BIOS.  There is no 'other half', the processor is
just pretending to have two cores by shuffling registers around, which
gives maybe a 5-10% performance gain in certain multithreaded
situations.  <opinion>A hack to overcome marchitactural limitations due
to the overly long pipeline in the Prescott core.</opinion>.  Really of
most use for desktop interactivity rather than actual throughput.

M

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Close
Дата:
Сообщение: Re: how much mem to give postgres?
Следующее
От: "Contact AR-SD.NET"
Дата:
Сообщение: Re: Index not used in query. Why?