Re: Performance Tuning Article - Mailing list pgsql-performance

From Frank Wiles
Subject Re: Performance Tuning Article
Date
Msg-id 20050623084854.0776d7a7.frank@wiles.org
Whole thread Raw
In response to Re: Performance Tuning Article  (Keith Worthington <KeithW@NarrowPathInc.com>)
List pgsql-performance
On Wed, 22 Jun 2005 22:31:29 -0400
Keith Worthington <KeithW@NarrowPathInc.com> wrote:

> Frank,
>
> A couple of things I wish I had been told when I started asking how to
>
> configure a new machine.
>
> Use RAID 10 (striping across mirrored disks)
>   or RAID 0+1 (mirror a striped array) for your data.
> Use RAID 1 (mirror) for your OS
> Use RAID 1 (mirror) for the WAL.
>
> Don't put anything else on the array holding the WAL.
>
> There have been problems with Xeon processors.

  I believe all of these issues are covered in the article, but
  obviously not clearly enough.  I'll work on rewording that section.

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------


pgsql-performance by date:

Previous
From: Radu-Adrian Popescu
Date:
Subject: Re: Performance Tuning Article
Next
From: Bruno Wolff III
Date:
Subject: Re: parameterized LIKE does not use index