pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Turner <armtuk@gmail.com>
To: Benjamin Wragg <bwragg@tpg.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disk configuration
Date: Thu, 20 Jan 2005 11:05:57 -0500
Message-ID: <33c6269f05012008054e094a4f@mail.gmail.com> (raw)
In-Reply-To: <20050120005537.AE5D08EAB6@vscan01.westnet.com.au>
References: <33c6269f050119075217a42c42@mail.gmail.com>
	<20050120005537.AE5D08EAB6@vscan01.westnet.com.au>

I have never seen benchmarks for RAID 0+1.  Very few people use it
because it's not very fault tolerant, so I couldn't answer for sure. 
I would imagine that RAID 0+1 could acheive better read throughput
because you could, in theory, read from each half of the mirror
independantly.  Write would be the same I would imagine because you
still have to write all data to all drives.  Thats my best guess.

Alex Turner
NetEconomist


On Thu, 20 Jan 2005 11:55:37 +1100, Benjamin Wragg <bwragg@tpg.com.au> wrote:
> 
> Thanks. That sorts out all my questions regarding disk configuration. One
> more regarding RAID. Is RAID 1+0 and 0+1 essentially the same at a
> performance level?
> 
> Thanks,
> 
> Benjamin
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Alex Turner
> Sent: Thursday, 20 January 2005 2:53 AM
> To: Benjamin Wragg
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Disk configuration
> 
> The primary goal is to reduce the number of seeks a disk or array has to
> perform.  Serial write throughput is much higher than random write
> throughput.  If you are performing very high volume throughput on a server
> that is doing multiple things, then it maybe advisable to have one partition
> for OS, one for postgresql binaries, one for xlog and one for table data (or
> multiple if you are PG8.0).  This is the ultimate configuration, but most
> people don't require this level of seperation.  If you do need this level of
> seperation, also bare in mind that table data writes are more likely to be
> random writes so you want an array that can sustain a high levels of IO/sec,
> so RAID 10 with 6 or more drives is ideal.  If you want fault tolerance,
> then RAID 1 for OS and postgresql binaries is a minimum, and I believe that
> xlog can also go on a RAID 1 unless you need more MB/sec.  Ultimately you
> will need to benchmark any configuration you build in order to determine if
> it's successfull and meets your needs.  This of course sucks, because you
> don't want to buy too much because it's a waste of $$s.
> 
> What I can tell you is my own experience which is a database running with
> xlog, software and OS on a RAID 1, with Data partition running on
> 3 disk RAID 5 with a database of about 3 million rows total gets an insert
> speed of about 200 rows/sec on an average size table using a compaq proliant
> ML370 Dual Pentium 933 w/2G RAM.  Most of the DB is in RAM, so read times
> are very good with most queries returning sub second.
> 
> Hope this helps at least a little
> 
> Alex Turner
> NetEconomist
> 
> On Wed, 19 Jan 2005 09:03:44 +1100, Benjamin Wragg <bwragg@tpg.com.au>
> wrote:
> >
> > I just wanted to bounce off the list the best way to configure disks
> > for a postgresql server. My gut feeling is as follows:
> >
> > Keep the OS and postgresql install on seperate disks to the postgresql
> > /data directory?
> > Is a single hard disk drive acceptable for the OS and postgresql
> > program, or will this create a bottle neck? Would a multi disk array
> > be more appropriate?
> >
> > Cheers,
> >
> > Benjamin Wragg
> >
> >
> > --
> >  No virus found in this outgoing message.
> >  Checked by AVG Anti-Virus.
> >  Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 265.7.1 - Release Date: 19/01/2005
> 
>



view thread (5+ messages)

Message-ID: <33c6269f05012008054e094a4f@mail.gmail.com>
Permalink:  ../33c6269f05012008054e094a4f@mail.gmail.com/
Also on:    postgresql.org/message-id/33c6269f05012008054e094a4f@mail.gmail.com

 · 

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: armtuk@gmail.com, bwragg@tpg.com.au
  Subject: Re: Disk configuration
  In-Reply-To: <33c6269f05012008054e094a4f@mail.gmail.com>

* 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