Re: High end server and storage for a PostgreSQL OLTP system

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Cosimo Streppone <cosimo(at)streppone(dot)it>
Cc: Postgresql Performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High end server and storage for a PostgreSQL OLTP system
Date: 2005-02-01 11:27:27
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

On Tue, Feb 01, 2005 at 07:35:35AM +0100, Cosimo Streppone wrote:
> >You might look at Opteron's, which theoretically have a higher data
> >bandwidth. If you're doing anything data intensive, like a sort in
> >memory, this could make a difference.
> Would Opteron systems need 64-bit postgresql (and os, gcc, ...)
> build to have that advantage?

Well, that would give you the most benefit, but the memory bandwidth is
still greater than on a Xeon. There's really no issue with 64 bit if
you're using open source software; it all compiles for 64 bits and
you're good to go. runs on a dual opteron
box running FreeBSD and I've had no issues.

> >RAID10 will be faster than RAID1.
> Sorry Jim, by RAID10 you mean several raid1 arrays mounted on
> different linux partitions? Or several raid1 arrays that
> build up a raid0 array? In the latter case, who decides which
> data goes in which raid1 array? Raid Adapter?

You should take a look around online for a description of raid types.

There's technically RAID0+1 and RAID1+0; one is a stripe of mirrored
drives (a RAID 0 built out of RAID 1s), the other is a mirror of two
RAID 0s. The former is much better; if you're lucky you can lose half
your drives without any data loss (if each dead drive is part of a
different mirror). Recovery is also faster.

You'll almost certainly be much happier with hardware raid instead of
software raid. runs a 3ware controller and SATA
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

In response to


Browse pgsql-performance by date

  From Date Subject
Next Message Sean Davis 2005-02-01 11:38:05 Re: [SQL] OFFSET impact on Performance???
Previous Message Bruno Almeida do Lago 2005-02-01 10:02:35 Very important choice