Re: Performance Tuning Article

From: Frank Wiles <frank(at)wiles(dot)org>
To: KeithW(at)NarrowPathInc(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Tuning Article
Date: 2005-06-23 13:48:54
Message-ID: 20050623084854.0776d7a7.frank@wiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 22 Jun 2005 22:31:29 -0400
Keith Worthington <KeithW(at)NarrowPathInc(dot)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(at)wiles(dot)org>
http://www.wiles.org
---------------------------------

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-23 14:18:54 Re: parameterized LIKE does not use index
Previous Message Radu-Adrian Popescu 2005-06-23 13:46:31 Re: Performance Tuning Article