On Mon, May 20, 2013 at 3:57 PM, Tomas Vondra 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.
On 20.5.2013 05:00, Greg Smith wrote:
> On 5/16/13 8:06 PM, Tomas Vondra wrote:
>> Have you considered using a UPS? That would make the SSDs about as
>> reliable as SATA/SAS drives - the UPS may fail, but so may a BBU unit on
>> the SAS controller.
>
> That's not true at all. Any decent RAID cont
ach wrote:
> One quick follow up since I'm expecting y'all might know: Do the
> statistics targets actually speed performance on an index search
> itself; the actual lookup? Or are the JUST to inform the planner
> towards the best pathway decision?
Since the statistics are just a random sampli