Postgres Pro
Downloads
Home   >   mailing lists

Re: What to do with 6 disks? - Mailing list pgsql-performance

From Vivek Khera
Subject Re: What to do with 6 disks?
Date
Msg-id bff7a565ea28cd62a757eb92edc1b59e@khera.org
Whole thread Raw
In response to Re: What to do with 6 disks?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
On Apr 19, 2005, at 11:07 PM, Josh Berkus wrote:

> RAID1 2 disks OS, pg_xlog
> RAID 1+0 4 disks pgdata
>

This is my preferred setup, but I do it with 6 disks on RAID10 for
data, and since I have craploads of disk space I set checkpoint
segments to 256 (and checkpoint timeout to 5 minutes)



Vivek Khera, Ph.D.
+1-301-869-4449 x806
Attachment

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Foreign key slows down copy/insert
Next
From: John A Meinel
Date:
Subject: Re: When are index scans used over seq scans?