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 on a 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 cache persistence in case of power failure), is a separate file system, not separate spindle. Especially if ext3 is used with 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 that much.
> 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
In response to
pgsql-performance by date
|Next:||From: Scott Carey||Date: 2010-06-22 17:30:35|
|Subject: ALTER Table and CLUSTER does adding a new column rewrite clustered?
|Previous:||From: Dave Crooke||Date: 2010-06-22 16:01:28|
|Subject: Re: raid10 write performance|