| From: | Karl Denninger <karl(at)denninger(dot)net> |
|---|---|
| To: | Justin Graf <justin(at)magwerks(dot)com> |
| Cc: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: raid10 write performance |
| Date: | 2010-06-22 14:29:53 |
| Message-ID: | 4C20C8E1.7060306@denninger.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Justin Graf wrote:
> On 6/22/2010 4:31 AM, Grzegorz Jaśkiewicz wrote:
>
>> Would moving WAL dir to separate disk help potentially ?
>>
>>
>
> Yes it can have a big impact.
WAL on a separate spindle will make a HUGE difference in performance.
TPS rates frequently double OR BETTER with WAL on a dedicated spindle.
Strongly recommended.
Be aware that you must pay CLOSE ATTENTION to your backup strategy if
WAL is on a different physical disk. Snapshotting the data disk where
WAL is on a separate spindle and backing it up **WILL NOT WORK** and
**WILL** result in an non-restoreable backup.
The manual discusses this but it's easy to miss.... don't or you'll get
a NASTY surprise if something goes wrong.....
-- Karl
| Attachment | Content-Type | Size |
|---|---|---|
| karl.vcf | text/x-vcard | 132 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-06-22 14:40:31 | Re: raid10 write performance |
| Previous Message | Justin Graf | 2010-06-22 13:40:03 | Re: raid10 write performance |