Re: SCSI vs SATA - Mailing list pgsql-performance

From jason@ohloh.net
Subject Re: SCSI vs SATA
Date
Msg-id 353D7681-0F87-4D44-9913-D71B8F9B1B1C@ohloh.net
Whole thread Raw
In response to Re: SCSI vs SATA  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-performance
On Apr 5, 2007, at 8:21 AM, Jeff Frost wrote:

> I noticed this behavior on the last Areca based 8 disk Raptor
> system I built. Putting pg_xlog on a separate partition on the same
> logical volume was faster than putting it on the large volume.  It
> was also faster to have 8xRAID10 for OS+data+pg_xlog vs 6xRAID10
> for data and 2xRAID1 for pg_xlog+OS.  Your workload may vary, but
> it's definitely worth testing.  The system in question had 1GB BBU.

Thanks for sharing your findings - I'll definitely try that config out.

-jay



pgsql-performance by date:

Previous
From: "Alex Deucher"
Date:
Subject: Re: postgres 7.4 vs 8.x redux: query plans
Next
From: "jason@ohloh.net"
Date:
Subject: Re: SCSI vs SATA