pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Wiles <frank@wiles.org>
To: alex@neteconomist.com
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Fri, 28 Jan 2005 10:17:24 -0600
Message-ID: <20050128101724.6777241d.frank@wiles.org> (raw)
In-Reply-To: <33c6269f0501280759d309de3@mail.gmail.com>
References: <330532b6050120104246597d2a@mail.gmail.com>
	<000001c4ff51$c0e985e0$e883f40a@br.gedasgrp>
	<20050128153138.GB9076@phlogiston.dyndns.org>
	<33c6269f0501280759d309de3@mail.gmail.com>

On Fri, 28 Jan 2005 10:59:58 -0500
Alex Turner <armtuk@gmail.com> wrote:

> At this point I will interject a couple of benchmark numbers based on
> a new system we just configured as food for thought.
> 
> System A (old system):
> Compaq Proliant Dual Pentium III 933 with Smart Array 5300, one RAID
> 1, one 3 Disk RAID 5 on 10k RPM drives, 2GB PC133 RAM.  Original
> Price: $6500
> 
> System B (new system):
> Self Built Dual Opteron 242 with 2x3ware 9500S-8MI SATA, one RAID 1
> (OS), one 4 drive RAID 10 (pg_xlog), one 6 drive RAID 10 (data) on 10k
> RPM Raptors, 4GB PC3200 RAM.  Current price $7200
> 
> System A for our large insert job: 125 minutes
> System B for our large insert job: 10 minutes.
> 
> There is no logical way there should be a 12x performance difference
> between these two systems,  maybe 2x or even 4x, but not 12x
> 
> Bad controler cards/configuration will seriously ruin your day.  3ware
> escalade cards are very well supported on linux, and work excellently.
>  Compaq smart array cards are not.  Bonnie++ benchmarks show a 9MB/sec
> write, 29MB/sec read on the RAID 5, but a 172MB/sec write on the
> 6xRAID 10, and 66MB/sec write on the RAID 1 on the 3ware.
> 
> With the right configuration you can get very serious throughput.  The
> new system is processing over 2500 insert transactions per second.  We
> don't need more RAM with this config.  The disks are fast enough. 
> 2500 transaction/second is pretty damn fast.

  I agree that badly supported or configured cards can ruin your
  performance. 

  However, don't you think moving pg_xlog onto a separate RAID and
  increasing your number of spindles from 3 to 6 on the data RAID would
  also have a significant impact on performance, no matter what card was
  used? 

  I'm not sure you can give all the credit to the card on this one. 

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------




view thread (131+ messages)  latest in thread

Message-ID: <20050128101724.6777241d.frank@wiles.org>
Permalink:  ../20050128101724.6777241d.frank@wiles.org/
Also on:    postgresql.org/message-id/20050128101724.6777241d.frank@wiles.org

 · 

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: frank@wiles.org, alex@neteconomist.com
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <20050128101724.6777241d.frank@wiles.org>

* 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