pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Arjen van der Meijden <acmmailing@tweakers.net>
To: pgsql-performance@postgresql.org
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date: Fri, 13 Aug 2010 07:59:29 +0200
Message-ID: <4C64DF41.40803@tweakers.net> (raw)
In-Reply-To: <FEDD0586-54B5-4F42-94AF-ACB3D89075E8@richrelevance.com>
References: <AANLkTikXLYc32Jyr5Fb8VeVNt6R86mCcF+0CkTHALd8W@mail.gmail.com>
	<BAE01AAD-6C69-48C7-BD2E-77E463D49903@richrelevance.com>
	<AANLkTi=km+H+mZ=yyx0_HTFZ-yU2sh85D+p5cs+ZcUSF@mail.gmail.com>
	<A1640F99-A7C5-4F04-9A25-782C46BE7DAB@richrelevance.com>
	<4C617C80.9080509@2ndquadrant.com>
	<72E29316-5F4C-4A01-8924-5340DF2FAE65@richrelevance.com>
	<4C6378F7.9040000@2ndquadrant.com>
	<FEDD0586-54B5-4F42-94AF-ACB3D89075E8@richrelevance.com>

On 13-8-2010 1:40 Scott Carey wrote:
> Agreed.  There is a HUGE gap between "ooh ssd's are fast, look!" and
> engineering a solution that uses them properly with all their
> strengths and faults.  And as 'gnuoytr' points out, there is a big
> difference between an Intel SSD and say, this thing:
> http://www.nimbusdata.com/products/s-class_overview.html

 From the description it sounds as if its either FreeBSD or OpenSolaris 
with ZFS with some webinterface-layer. That's not a bad thing per se, 
but as the site suggests its 'only' $25k for the smallest (2.5TB?) 
device. That makes it very likely that it are "off the shelf" MLC flash 
drives. Given the design of the device and the pricing it probably are 
your average 2.5"-drives with 100, 200 or 400GB capacity (maybe OCZ 
vertex 2 pro, which do have such a capacitor?), similar to the Intel SSD 
you compared it to.
And than we're basically back to square one, unless the devices have a 
capacitor or ZFS works better with SSD-drives to begin with (it will at 
least know silent data corruption did occur).

There are of course devices that are not built on top of normal disk 
form factor SSD-drives like the Ramsan devices or Sun's F5100.

Best regards,

Arjen



view thread (37+ messages)  latest in thread

Message-ID: <4C64DF41.40803@tweakers.net>
Permalink:  ../4C64DF41.40803@tweakers.net/
Also on:    postgresql.org/message-id/4C64DF41.40803@tweakers.net

 · 

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: acmmailing@tweakers.net
  Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
  In-Reply-To: <4C64DF41.40803@tweakers.net>

* 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