Re: Considering Solid State Drives - Mailing list pgsql-general

From Vick Khera
Subject Re: Considering Solid State Drives
Date
Msg-id AANLkTi=bpwTcXLm=BhBZsn0DvZBkyNcGz8+7cE=DBnLc@mail.gmail.com
Whole thread Raw
In response to Considering Solid State Drives  (Allan Kamau <kamauallan@gmail.com>)
Responses Re: Considering Solid State Drives  (David Siebert <david@aretoo.com>)
Re: Considering Solid State Drives  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
On Thu, Nov 11, 2010 at 1:42 AM, Allan Kamau <kamauallan@gmail.com> wrote:
> After googling I found little resent content (including survival
> statistics) of using SSDs in a write intensive database environment.
>

We use the Texas Memory RAMSan-620 external disk units.  It is
designed specifically to survive high write loads, and uses internal
monitoring and load leveling and spare parts with internal RAID
configuration to keep from losing data in the eventual case when the
SSD chips wear out.  When that happens, you just swap out the failed
piece and it keeps humming along.

I wouldn't trust an SSD as a stand-alone drive for a DB.  At minimum,
I'd RAID1 them using the SATA controller... but be sure to get SATA3
or even better SAS connected drives if you want to maximize the speed.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9
Next
From: tv@fuzzy.cz
Date:
Subject: Re: good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9