Re: Reports from SSD purgatory

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: gnuoytr(at)rcn(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Reports from SSD purgatory
Date: 2011-08-24 19:32:16
Message-ID: d32d411b09d8e7c614772de567a94229.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 24 Srpen 2011, 20:48, gnuoytr(at)rcn(dot)com wrote:

> It's worth knowing exactly what that means. Turns out that NAND quality
> is price specific. There's gooduns and baduns. Is this a failure in the
> controller(s) or the NAND?

Why is that important? It's simply a failure of electronics and it has
nothing to do with the wear limits. It simply fails without prior warning
from the SMART.

> Also, given that PG is *nix centric and support for TRIM is win centric,
> having that makes a big difference in performance.

Windows specific? What do you mean? TRIM is a low-level way to tell the
drive 'this block is empty and may be used for something else' - it's just
another command sent to the drive. It has to be supported by the
filesystem, though (e.g. ext4/btrfs support it).

Tomas

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2011-08-24 19:41:47 Re: Reports from SSD purgatory
Previous Message david 2011-08-24 19:13:38 Re: Reports from SSD purgatory