From: Cosimo Streppone <cosimo@streppone.it>
To: Jim C. Nasby <decibel@decibel.org>
Cc: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: High end server and storage for a PostgreSQL OLTP system
Date: Tue, 01 Feb 2005 07:35:35 +0100
Message-ID: <41FF2337.7070809@streppone.it> (raw)
In-Reply-To: <20050201045645.GC32356@decibel.org>
References: <41FE97FC.3060106@streppone.it>
<20050201045645.GC32356@decibel.org>
Jim C. Nasby wrote:
> On Mon, Jan 31, 2005 at 09:41:32PM +0100, Cosimo wrote:
>
> >2) The goal is to make the db handle 100 tps (something like
> > 100 users). What kind of server and storage should I provide?
>
> 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?
> >4) Is it correct to suppose that multiple RAID 1 arrays
> > can provide the fastest I/O ?
> > I usually reserve one RAID1 array to db data directory,
> > one RAID1 array to pg_xlog directory and one RAID1 array
> > for os and application needs.
>
> 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?
> The key factor to a high performance database is a high
> performance I/O system. If you look in the archives
> you'll find people running postgresql on 30 and 40
> drive arrays.
I'll do a search, thank you.
--
Cosimo
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: cosimo@streppone.it, decibel@decibel.org
Subject: Re: High end server and storage for a PostgreSQL OLTP system
In-Reply-To: <41FF2337.7070809@streppone.it>
* 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