Re: Hardware performance

Andrew Sullivan <andrew@libertyrms.info>

From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Date: 2003-07-17T18:41:52Z
Lists: pgsql-performance
On Thu, Jul 17, 2003 at 07:57:53AM -0700, Joe Conway wrote:
> 
> As I said, I've never personally found it necessary to move WAL off to a 
> different physical drive. What do you think is the best configuration 

On our Solaris test boxes (where, alas, we do not have the luxury of
1/2 TB external RAID boxes :-( ), putting WAL on a disk of its own
yielded something like 30% improvement in throughput on high
transaciton volumes.  So it's definitely important in some cases.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110