Re: ProstGreSQL on RAID Question - Mailing list pgsql-admin

From Curt Sampson
Subject Re: ProstGreSQL on RAID Question
Date
Msg-id Pine.NEB.4.44.0208121228540.2317-100000@angelic.cynic.net
Whole thread Raw
In response to ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
Responses Re: ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
List pgsql-admin
On Mon, 12 Aug 2002, Chris Ruprecht wrote:

> I have set up a RAID-5 (soft RAID) arrray on my Linux machine,
> consisting of 5 18 GB UltraSCSI-2 (80 MB/sec) drives. Everythinng is
> working but I would like to know, where I can tweak this for optimum
> performance.

If you do a lot of inserts, move the log file ($PGDATA/pg_xlog)
off the RAID-5 and on to a separate RAID-1 (mirrored) pair. This will
separate the buffered random writes to the data files and the unbuffered,
sequential writes to the log.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-admin by date:

Previous
From: Chris Ruprecht
Date:
Subject: ProstGreSQL on RAID Question
Next
From: Chris Mungall
Date:
Subject: Re: abnormally long time in performing a two-table join