Re: Database Server Tuning - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Database Server Tuning
Date
Msg-id 0BD83171-6C91-11D8-95B1-000A9578CFCC@kcilink.com
Whole thread Raw
In response to Re: Database Server Tuning  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Database Server Tuning
List pgsql-performance
On Mar 2, 2004, at 4:27 PM, Josh Berkus wrote:

> Vivek,
>
>> I did a bunch of testing with different RAID levels on a 14 disk
>> array.  I finally settled on this:  RAID5 across 14 disks for the
>> data, the OS (including syslog directory) and WAL on a RAID1 pair on
>> the other channel of the same controller (I didn't want to spring for
>


> With large RAID, have you found that having WAL on a seperate array
> actually
> boosts performance?   The empirical tests we've seen so far don't seem
> to
> support this.

Yes, it was a noticeable improvement.


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Scaling further up
Next
From: "Simon Riggs"
Date:
Subject: Re: WAL Optimisation - configuration and usage