From: Scott Marlowe <scott.marlowe@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Carlo Stonebanks <stonec.register@sympatico.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: Tue, 4 Sep 2007 18:15:16 -0500
Message-ID: <dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com> (raw)
In-Reply-To: <20070904230639.GA23731@alvh.no-ip.org>
References: <fbkn5d$cfq$1@news.hub.org>
<20070904230639.GA23731@alvh.no-ip.org>
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.
Egads, I'd completely missed the word Windows up there.
I would highly recommend building the postgresql server on a unixish
OS. Even with minimum tuning, I'd expect the same box running linux
or freebsd to stomp windows pretty heavily in the performance
department.
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, alvherre@commandprompt.com, stonec.register@sympatico.ca
Subject: Re: Performance on 8CPU's and 32GB of RAM
In-Reply-To: <dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox