Re: Reliability with RAID 10 SSD and Streaming Replication

On Fri, May 17, 2013 at 8:17 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Fri, May 17, 2013 at 1:34 AM, David Rees <drees76(at)gmail(dot)com> wrote:
>> On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang <climbingrose(at)gmail(dot)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