Re: Database Server Tuning

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database Server Tuning
Date: 2004-03-02 21:32:03
Message-ID: 0BD83171-6C91-11D8-95B1-000A9578CFCC@kcilink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anjan Dave 2004-03-02 21:50:04 Re: Scaling further up
Previous Message Josh Berkus 2004-03-02 21:27:37 Re: Database Server Tuning