From: Carlo Stonebanks <stonec.register@sympatico.ca>
To: 'Scott Marlowe' <scott.marlowe@gmail.com>
To: 'Alvaro Herrera' <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: Wed, 5 Sep 2007 11:06:03 -0400
Message-ID: <3DCCF196F82444998B33F40C97B71CA4@serenity> (raw)
In-Reply-To: <dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
References: <fbkn5d$cfq$1@news.hub.org>
<20070904230639.GA23731@alvh.no-ip.org>
<dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
Unfortunately, LINUX is not an option at this time. We looked into it; there
is no *NIX expertise in the enterprise. However, I have raised this issue in
various forums before, and when pressed no one was willing to say that "*NIX
*DEFINITELY* outperforms Windows" for what my client is doing (or if it did
outperform Windows, that it would outperform so significantly that it
merited the move).
Was this incorrect? Can my client DEFINITELY expect a significant
improvement in performance for what he is doing?
DISK subsystem reports: SCSI/RAID Smart Array E200 controller using RAID 1.
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: September 4, 2007 7:15 PM
To: Alvaro Herrera
Cc: Carlo Stonebanks; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Performance on 8CPU's and 32GB of RAM
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: stonec.register@sympatico.ca, scott.marlowe@gmail.com, alvherre@commandprompt.com
Subject: Re: Performance on 8CPU's and 32GB of RAM
In-Reply-To: <3DCCF196F82444998B33F40C97B71CA4@serenity>
* 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