Re: SSDs with Postgresql? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: SSDs with Postgresql?
Date
Msg-id BANLkTimUtTmfSqY+r+2Lty8ErQUsHQLR0Q@mail.gmail.com
Whole thread Raw
In response to Re: SSDs with Postgresql?  ("Henry C." <henka@cityweb.co.za>)
Responses Re: SSDs with Postgresql?
List pgsql-general
On Thu, Apr 14, 2011 at 3:40 AM, Henry C. <henka@cityweb.co.za> wrote:
>
> On Thu, April 14, 2011 10:51, Craig Ringer wrote:
>> On 14/04/2011 4:35 PM, Henry C. wrote:
>>
>>
>>> There is no going back.  Hint: don't use cheap SSDs - cough up and use
>>> Intel.
>>>
>>
>> The server-grade SLC stuff with a supercap, I hope, not the scary
>> consumer-oriented MLC "pray you weren't writing anything during power-loss"
>> devices?
>
> That's what a UPS and genset are for.  Who writes critical stuff to *any*
> drive without power backup?

Because power supply systems with UPS never fail.

(hint, I've seen them fail, more than once)

pgsql-general by date:

Previous
From: Wim Bertels
Date:
Subject: function to filter out tokens (sql syntax lexical)?
Next
From: David Kerr
Date:
Subject: Calculating memory allocaiton per process