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

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: 2007-09-05 08:20:31
Message-ID: 46DE66CF.9000903@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 05.09.2007 01:15, Scott Marlowe wrote:
> On 9/4/07, Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message JS Ubei 2007-09-05 09:53:22 optimize query with a maximum(date) extraction
Previous Message Daniel Rubio 2007-09-05 07:31:05 No pg_dumplo on 8.2.4