Re: Performance on 8CPU's and 32GB of RAM

Поиск
Список
Период
Сортировка
От Hannes Dorbath
Тема Re: Performance on 8CPU's and 32GB of RAM
Дата
Msg-id 46DE66CF.9000903@theendofthetunnel.de
обсуждение исходный текст
Ответ на Re: Performance on 8CPU's and 32GB of RAM  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Performance on 8CPU's and 32GB of RAM  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-performance
On 05.09.2007 01:15, Scott Marlowe wrote:
> On 9/4/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
>> Carlo Stonebanks wrote:
>>> A client is moving their postgresql db to a brand new Windows 2003 x64
>>> server with 2 quad cores and 32GB of RAM. It is a dedicated server to run
>>> 8.2.4.
>> Large shared_buffers and Windows do not mix.  Perhaps you should leave
>> the shmem config low, so that the kernel can cache the file pages.
>
> But yeah, the I/O, that's the big one.  If it's just a single or a
> couple of IDE drives, it's not gonna be able to handle much load.

Right, additionally NTFS is really nothing to use on any serious disc array.


--
Regards,
Hannes Dorbath

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Vacum Analyze problem
Следующее
От: JS Ubei
Дата:
Сообщение: optimize query with a maximum(date) extraction