On Jun 22, 2010, at 7:29 AM, Karl Denninger wrote:
> 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
ona dedicated spindle.
>
> Strongly recommended.
>
Most of the performance increase on Linux, if your RAID card has a data-safe write-back cache (battery or solid state
cachepersistence in case of power failure), is a separate file system, not separate spindle. Especially if ext3 is
usedwith the default "ordered" journal, it is absolutely caustic to performance to have WAL and data on the same file
system.
The whole 'separate spindle' thing is important if you don't have a good caching raid card, otherwise it doesn't matter
thatmuch.
> Be aware that you must pay CLOSE ATTENTION to your backup strategy if WAL is on a different physical disk.
Snapshottingthe data disk where WAL is on a separate spindle and backing it up **WILL NOT WORK** and **WILL** result in
annon-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
> <karl.vcf><ATT00001..txt>