Re: Reliability with RAID 10 SSD and Streaming Replication

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Reliability with RAID 10 SSD and Streaming Replication
Дата
Msg-id CAHyXU0zhOiHp+=BSRDx57BMQpdre2CgaqejXcKwsMf5zb-J9EA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reliability with RAID 10 SSD and Streaming Replication  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Reliability with RAID 10 SSD and Streaming Replication
Следующее
От: Sékine Coulibaly
Дата:
Сообщение: Re: Deleting Rows From Large Tables