| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance on 8CPU's and 32GB of RAM |
| Date: | 2007-09-04 23:15:16 |
| Message-ID: | dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-09-04 23:24:32 | Re: Vacum Analyze problem |
| Previous Message | Alvaro Herrera | 2007-09-04 23:06:39 | Re: Performance on 8CPU's and 32GB of RAM |