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>>

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to