pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Weimann <cweimann@k12hq.com>
To: alex@neteconomist.com
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: Fri, 28 Jan 2005 11:54:57 -0500
Message-ID: <20050128165457.GA2280@tektite.k12usa.internal> (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 01/28/2005-10:59AM, Alex Turner 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
> 

Your system A has the absolute worst case Raid 5, 3 drives. The more
drives you add to Raid 5 the better it gets but it will never beat Raid
10. On top of it being the worst case, pg_xlog is not on a separate
spindle.

Your system B has a MUCH better config. Raid 10 is faster than Raid 5 to
begin with but on top of that you have more drives involved plus pg_xlog
is on a separate spindle.

I'd say I am not surprised by your performance difference.

> 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.
> 

What does bonnie say about the Raid 1 on the Compaq? Comparing the two
Raid 1s is really the only valid comparison that can be made between
these two machines.  Other than that you are comparing apples to 
snow shovels.




view thread (131+ messages)  latest in thread

Message-ID: <20050128165457.GA2280@tektite.k12usa.internal>
Permalink:  ../20050128165457.GA2280@tektite.k12usa.internal/
Also on:    postgresql.org/message-id/20050128165457.GA2280@tektite.k12usa.internal

 · 

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: cweimann@k12hq.com, alex@neteconomist.com
  Subject: Re: PostgreSQL clustering VS MySQL clustering
  In-Reply-To: <20050128165457.GA2280@tektite.k12usa.internal>

* 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