Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group