Re: Some ideas about Vacuum

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>, "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Some ideas about Vacuum
Date: 2008-01-16 18:01:30
Message-ID: 478DF219.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> On Wed, Jan 16, 2008 at 11:40 AM, in message
<Pine(dot)GSO(dot)4(dot)64(dot)0801161233260(dot)20980(at)westnet(dot)com>, Greg Smith
<gsmith(at)gregsmith(dot)com> wrote:
> On Wed, 16 Jan 2008, Alvaro Herrera wrote:
>
>> Keep in mind that there are claims that a write-cache-enabled
>> battery-backed RAID controller negates the effect of a separate spindle.
>
> "Negates" is a bit strong; there's still some performance advantage on
> systems that write a serious amount of data. It's certainly true that a
> BCC controller greatly reduces the need for a separate spindle.

I haven't seen any benchmarks on the list or in our environment
where the separate spindles gave more than a 1% increase in
performance when using a good-quality BBC controller. Do you have
results that show more of a difference? Can you share them?

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-01-16 18:41:45 Re: Some ideas about Vacuum
Previous Message Stephen Frost 2008-01-16 17:50:41 Re: postgresql in FreeBSD jails: proposal