Re: SCSI vs SATA

From: "jason(at)ohloh(dot)net" <jason(at)ohloh(dot)net>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Geoff Tolley <geoff(at)polimetrix(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: SCSI vs SATA
Date: 2007-04-05 15:38:58
Message-ID: 353D7681-0F87-4D44-9913-D71B8F9B1B1C@ohloh.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message jason@ohloh.net 2007-04-05 15:58:54 Re: SCSI vs SATA
Previous Message Alex Deucher 2007-04-05 15:34:57 Re: postgres 7.4 vs 8.x redux: query plans