pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Carey <scott@richrelevance.com>
To: Andy <angelflow@yahoo.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Greg Smith <greg@2ndquadrant.com>
Subject: Re: Intel SSDs that may not suck
Date: Wed, 6 Apr 2011 17:20:21 -0700
Message-ID: <C9C25083.2EB4E%scott@richrelevance.com> (raw)
In-Reply-To: <312218.14775.qm@web111305.mail.gq1.yahoo.com>



On 4/6/11 2:11 PM, "Andy" <angelflow@yahoo.com> wrote:

>
>--- On Wed, 4/6/11, Scott Carey <scott@richrelevance.com> wrote:
>
>
>> I could care less about the 'fast' sandforce drives.
>> They fail at a high
>> rate and the performance improvement is BECAUSE they are
>> using a large,
>> volatile write cache.
>
>The G1 and G2 Intel MLC also use volatile write cache, just like most
>SandForce drives do.

1. People are complaining that the Intel G3's aren't as fast as the
SandForce drives (they are faster than the 1st gen SandForce, but not the
yet-to-be-released ones like Vertex 3).  From a database perspective, this
is complete BS.

2. 256K versus 64MB write cache.   Power + time to flush a cache matters.

3. None of the performance benchmarks of drives are comparing the
performance with the cache _disabled_ which is required when not power
safe.  If the SandForce drives are still that much faster with it
disabled, I'd be shocked.  Disabling a 256K write cache will affect
performance less than disabling a 64MB one.




view thread (35+ messages)  latest in thread

Message-ID: <C9C25083.2EB4E%scott@richrelevance.com>
Permalink:  ../C9C25083.2EB4E%25scott@richrelevance.com/
Also on:    postgresql.org/message-id/C9C25083.2EB4E%scott@richrelevance.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: scott@richrelevance.com, angelflow@yahoo.com, mmoncure@gmail.com, greg@2ndquadrant.com
  Subject: Re: Intel SSDs that may not suck
  In-Reply-To: <C9C25083.2EB4E%scott@richrelevance.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