Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID - Mailing list pgsql-general

From John R Pierce
Subject Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Date
Msg-id 519048C5.3040309@hogranch.com
Whole thread Raw
In response to Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
List pgsql-general
On 5/12/2013 6:41 PM, David Boreham wrote:
> Agreed. I don't go near the likes of Simple, HGST, F-IO, SMART, et al.
> For me this is SAS and SCSI re-born -- an excuse to charge very high
> prices for a product not significantly different from a much cheaper
> mainstream alternative, by exploiting unsophisticated purchasers with
> tales of enterprise snake oil.
>
> ymmv, but since I am spending my own $$, I'll stick to product I can
> order from the likes of Newegg and Amazon.

except, those high end enterprise products ARE write-safe while most
SATA SSD's aren't.   The enterprise SSD's like STEC are engineered for
much higher write cycle life times.   the whole storage infrastructure
has several more 9's on its reliability.   those extra 9's don't come
cheap.   and if [Bigname Vendor] sells you a system with storage
controller X and drives Y, you can generally assume they've been tested
together.    they are also selling their service and support, for better
or worse.

SAS has better IO concurrency than SATA, and SAS drives are dual path,
which means you can have redundant storage channels and cabling, even if
you're doing JBOD..

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: David Boreham
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: In what situations do you use -U of initdb?