Re: Choosing a filesystem - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: Choosing a filesystem
Date
Msg-id 873ak5iwru.fsf@mnc.ch
Whole thread Raw
In response to Re: Choosing a filesystem  (Craig James <craig_james@emolecules.com>)
Responses Re: Choosing a filesystem
List pgsql-performance
Craig James <craig_james 'at' emolecules.com> writes:

> The performance improvement of a BB cache is amazing.

Could some of you share the insight on why this is the case? I
cannot find much information on it on wikipedia, for example.
Even http://linuxfinances.info/info/diskusage.html doesn't
explain *why*.

Out of the blue, is it just because when postgresql fsync's after
a write, on a normal system the write has to really happen on
disk and waiting for it to be complete, whereas with BBU cache
the fsync is almost immediate because the write cache actually
replaces the "really on disk" write?

--
Guillaume Cottenceau, MNC Mobile News Channel SA, an Alcatel-Lucent Company
Av. de la Gare 10, 1003 Lausanne, Switzerland - direct +41 21 317 50 36

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: Choosing a filesystem
Next
From: Greg Smith
Date:
Subject: Re: Choosing a filesystem