pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: Suggestions for Intel 710 SSD test
Date: Sun, 02 Oct 2011 21:35:43 -0700
Message-ID: <4E893B9F.1070300@2ndQuadrant.com> (raw)
In-Reply-To: <4E87CEDF.3000504@boreham.org>
References: <4E87CEDF.3000504@boreham.org>

On 10/01/2011 07:39 PM, David Boreham wrote:
> I've already tried bonnie++, sysbench and a simple WAL emulation
> test program I wrote more than 10 years ago.  The drive tests at
> around 160Mbyte/s on bulk data and 4k tps for commit rate writing
> small blocks.

That sounds about the same performance as the 320 drive I tested earlier 
this year then.  You might try duplicating some of the benchmarks I ran 
on that:  
http://archives.postgresql.org/message-id/4D9D1FC3.4020207@2ndQuadrant.com

Make sure to reference the capacity of the drive though.  The 320 units 
do scale their performance based on that, presumably there's some of 
that with the 710s as well.

I just released a new benchmarking wrapper to measure seek performance 
of drives and graph the result, and that's giving me interesting results 
when comparing the 320 vs. traditional disk arrays.  I've attached a 
teaser output from it on a few different drive setups I've tested 
recently.  (The 320 test there was seeking against a smaller data set 
than the regular arrays, but its performance doesn't degrade much based 
on that anyway)

The program is at https://github.com/gregs1104/seek-scaling but it's 
still quite rough to use.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us

Attachments:

array-vs-ssd.png (image/png, 5.4K) download view image

view thread (14+ messages)  latest in thread

Message-ID: <4E893B9F.1070300@2ndQuadrant.com>
Permalink:  ../4E893B9F.1070300@2ndQuadrant.com/
Also on:    postgresql.org/message-id/4E893B9F.1070300@2ndQuadrant.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: greg@2ndQuadrant.com
  Subject: Re: Suggestions for Intel 710 SSD test
  In-Reply-To: <4E893B9F.1070300@2ndQuadrant.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