Re: New server: SSD/RAID recommendations? - Mailing list pgsql-performance

From Graeme B. Bell
Subject Re: New server: SSD/RAID recommendations?
Date
Msg-id AB056B38-EC0F-46B6-90E6-0963604E0A9B@skogoglandskap.no
Whole thread Raw
In response to Re: New server: SSD/RAID recommendations?  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: New server: SSD/RAID recommendations?  (Vitalii Tymchyshyn <vit@tym.im>)
Re: New server: SSD/RAID recommendations?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Yikes. I would not be able to sleep tonight if it were not for the BBU cache in front of these disks...

diskchecker.pl consistently reported several examples of corruption post-power-loss (usually 10 - 30 ) on unprotected
M500s/M550s,so I think it's pretty much open to debate what types of madness and corruption you'll find if you look
closeenough. 

G


On 07 Jul 2015, at 16:59, Heikki Linnakangas <hlinnaka@iki.fi> wrote:

>
> So it lies about fsync()... The next question is, does it nevertheless enforce the correct ordering of persisting
fsync'ddata? If you write to file A and fsync it, then write to another file B and fsync it too, is it guaranteed that
ifB is persisted, A is as well? Because if it isn't, you can end up with filesystem (or database) corruption anyway. 
>
> - Heikki



pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: New server: SSD/RAID recommendations?
Next
From: Tom Lane
Date:
Subject: Re: wildcard text filter switched to boolean column, performance is way worse