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 CAHyXU0zhOiHp+=BSRDx57BMQpdre2CgaqejXcKwsMf5zb-J9EA@mail.gmail.com
Whole thread Raw
In response to Re: Reliability with RAID 10 SSD and Streaming Replication  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
On Fri, May 17, 2013 at 8:17 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Fri, May 17, 2013 at 1:34 AM, David Rees <drees76@gmail.com> wrote:
>> On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang <climbingrose@gmail.com> wrote:
>>> For our application, a few seconds of data loss is acceptable.
>>
>> If a few seconds of data loss is acceptable, I would seriously look at
>> the synchronous_commit setting and think about turning that off rather
>> than risk silent corruption with non-enterprise SSDs.
>
> That is not going to help.


whoops -- misread your post heh (you were suggesting to use classic
hard drives).  yeah, that might work but it only buys you so much
particuarly if there is a lot of random activity in the heap.

merlin


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Next
From: Sékine Coulibaly
Date:
Subject: Re: Deleting Rows From Large Tables