Skip site navigation (1) Skip section navigation (2)

Re: Configuring PostgreSQL to minimize impact of checkpoints

From: Paul Tuckfield <paul(at)tuckfield(dot)com>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(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 21:52:57
Message-ID: 905B43ED-A395-11D8-A34F-000393BD6C3E@tuckfield.com (view raw or flat)
Thread:
Lists: pgsql-performance
Love that froogle.

It looks like a nice card.     One thing I didn't get straight is if 
the cache is writethru or write back.

If the original posters problem is truly a burst write problem (and not 
linux caching or virtual memory overcommitment) then writeback is key.




> 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.
>
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly
>


In response to

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2004-05-11 22:07:36
Subject: Re: Configuring PostgreSQL to minimize impact of checkpoints
Previous:From: Rob SellDate: 2004-05-11 21:47:05
Subject: Re: Configuring PostgreSQL to minimize impact of checkpoints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group