| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Szymon Guz <mabewlun(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about configuration and SSD |
| Date: | 2011-06-02 08:53:09 |
| Message-ID: | 4DE74F75.6030204@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
If the SSDs have a supercap or a battery backed write cache so that they
can guarantee that all cached data will be written out if the power goes
down, you won't need any special configuration. You may want to tune
differently for best performance, though - for example, reducing
random_page_cost .
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ognjen Blagojevic | 2011-06-02 09:19:03 | Re: Need suggestion |
| Previous Message | Szymon Guz | 2011-06-02 08:26:59 | Question about configuration and SSD |