Skip site navigation (1) Skip section navigation (2)

Re: raid10 write performance

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 (view raw or flat)
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: karl.vcf
Description: text/x-vcard (131 bytes)

In response to

Responses

pgsql-performance by date

Next:From: Greg SmithDate: 2010-06-22 14:40:31
Subject: Re: raid10 write performance
Previous:From: Justin GrafDate: 2010-06-22 13:40:03
Subject: Re: raid10 write performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group