| From: | "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, "Szymon Guz" <mabewlun(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question about configuration and SSD |
| Date: | 2011-06-03 13:04:50 |
| Message-ID: | C4DAC901169B624F933534A26ED7DF310861AF2B@JENMAIL01.ad.intershop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2011-06-03 13:53:17 | Re: Hidden Risk w/ UPDATE Cascade and Trigger-Based Validation |
| Previous Message | Michal Politowski | 2011-06-03 13:03:57 | Re: Mixed up protocol packets in server response? |