Re: Configuring System for Speed - Mailing list pgsql-performance

From Brian Wipf
Subject Re: Configuring System for Speed
Date
Msg-id A0D70FD2-8888-4455-9F88-62AF35234026@clickspace.com
Whole thread Raw
In response to Re: Configuring System for Speed  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Configuring System for Speed
List pgsql-performance
On 8-Sep-06, at 2:44 AM, Luke Lonergan wrote:

> One modification: we implemented two internal 60GB laptop hard
> drives with
> an additional 3Ware 8006-2LP controller on each machine for the OS.
> This
> frees up all 16 SATA II drives for data.

That's a great idea. One question though. If I put all 16 drives in a
RAID 10 for the database, where should I put the logs? On that large
RAID set? If I use a RAID controller with a BB cache for the mirrored
laptop drives, might I be able to use that for the logs and OS?

Brian Wipf


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Abysmal hash join
Next
From: Florian Weimer
Date:
Subject: Re: Abysmal hash join