Re: Configuring PostgreSQL to minimize impact of checkpoints

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Paul Tuckfield <paul(at)tuckfield(dot)com>
Cc: <jao(at)geophile(dot)com>, Matthew Nuzum <cobalt(at)bearfruit(dot)org>, <pgsql-performance(at)postgresql(dot)org>, Rob Fielding <rob(at)dsvr(dot)net>
Subject: Re: Configuring PostgreSQL to minimize impact of checkpoints
Date: 2004-05-11 20:22:40
Message-ID: Pine.LNX.4.33.0405111417380.23073-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 11 May 2004, Paul Tuckfield wrote:

> If you are having a "write storm" or bursty writes that's burying
> performance, a scsi raid controler with writeback cache will greatly
> improve the situation, but I do believe they run around $1-2k. If
> it's write specific problem, the cache matters more than the striping,
> except to say that write specfic perf problems should avoid raid5

Actually, a single channel MegaRAID 320-1 (single channel ultra 320) is
only $421 at http://www.siliconmechanics.com/c248/u320-scsi.php It works
pretty well for me, having 6 months of a production server on one with
zero hickups and very good performance. They have a dual channel intel
card for only $503, but I'm not at all familiar with that card.

The top of the line megaraid is the 320-4, which is only $1240, which
ain't bad for a four channel RAID controller.

Battery backed cache is an addon, but I think it's only about $80 or so.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bjoern Metzdorf 2004-05-11 20:28:12 Re: [PERFORM] Quad processor options
Previous Message scott.marlowe 2004-05-11 20:16:36 Re: [PERFORM] Quad processor options