Re: Question about configuration and SSD - Mailing list pgsql-general

From Marc Mamin
Subject Re: Question about configuration and SSD
Date
Msg-id C4DAC901169B624F933534A26ED7DF310861AF2B@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: Question about configuration and SSD  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
 
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Craig Ringer
> Sent: Donnerstag, 2. Juni 2011 10:53
> 
> On 02/06/11 16:26, Szymon Guz wrote:
> > Hi,
> > do we need some special configuration for SSD drives, or is that enough
> > to treat those drives normally?
> 
> Make sure the SSDs have a supercapacitor or battery backup for their
> write cache. If they do not, then do not use them unless you can disable
> write caching completely (probably resulting in horrible performance),
> because you WILL get a corrupt database when power fails.
> ... 


Hello, 

may the database also get corrupt if SSDs are only used for temp tablespaces ?
And will Postgres fall back on another temp tablespace if one get down? 

regards,

Marc Mamin

pgsql-general by date:

Previous
From: Michal Politowski
Date:
Subject: Re: Mixed up protocol packets in server response?
Next
From: Dean Rasheed
Date:
Subject: Re: Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation