Re: BBU Cache vs. spindles - Mailing list pgsql-performance

From Andres Freund
Subject Re: BBU Cache vs. spindles
Date
Msg-id 201010212218.09609.andres@anarazel.de
Whole thread Raw
In response to Re: BBU Cache vs. spindles  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
On Thursday 21 October 2010 21:42:06 Kevin Grittner wrote:
> Bruce Momjian <bruce@momjian.us> wrote:
> > I assume we send a full 8k to the controller, and a failure during
> > that write is not registered as a write.
>
> On what do you base that assumption?  I assume that we send a full
> 8K to the OS cache, and the file system writes disk sectors
> according to its own algorithm.  With either platters or BBU cache,
> the data is persisted on fsync; why do you see a risk with one but
> not the other?
At least on linux pages can certainly get written out in < 8kb batches if
youre under memory pressure.

Andres



pgsql-performance by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Index scan is not working, why??
Next
From: Scott Carey
Date:
Subject: Re: Slow count(*) again...