Re: Reliability with RAID 10 SSD and Streaming Replication - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Reliability with RAID 10 SSD and Streaming Replication
Date
Msg-id CAHyXU0wvW-USgbkXAYEHLG2fHgj=UdZi1aCFoVWBMQEsOFZy+A@mail.gmail.com
Whole thread Raw
In response to Re: Reliability with RAID 10 SSD and Streaming Replication  (Tomas Vondra <tv@fuzzy.cz>)
Responses Re: Reliability with RAID 10 SSD and Streaming Replication  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-performance
On Mon, May 20, 2013 at 3:57 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
> But yes, I do agree that the provider should be ashamed for not
> providing reliable SSDs in the first place. Getting reliable SSDs should
> be the first option - all these suggestions are really just workarounds
> of this rather simple issue.

Absolutely.  Reliable SSD should be the first and only option.  They
are significantly more expensive (more than 2x) but are worth it.

When it comes to databases, particularly in the open source postgres
world, hard drives are completely obsolete.  SSD are a couple of
orders of magnitude faster and this (while still slow in computer
terms) is fast enough to put storage into the modern area by anyone
who is smart enough to connect a sata cable.  While everyone likes to
obsess over super scalable architectures technology has finally
advanced to the point where your typical SMB system can be handled by
a sincle device.

merlin


pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Next
From: Sameer Thakur
Date:
Subject: pg_statsinfo : error could not connect to repository