Re: Configuring System for Speed

From: Brian Wipf <brian(at)clickspace(dot)com>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuring System for Speed
Date: 2006-09-11 15:50:43
Message-ID: A0D70FD2-8888-4455-9F88-62AF35234026@clickspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Florian Weimer 2006-09-11 16:28:49 Re: Abysmal hash join
Previous Message Tom Lane 2006-09-11 15:39:58 Re: Abysmal hash join