pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (21+ messages)  latest in thread

Message-ID: <41FF2337.7070809@streppone.it>
Permalink:  ../41FF2337.7070809@streppone.it/
Also on:    postgresql.org/message-id/41FF2337.7070809@streppone.it

 · 

reply

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