Re: new server I/O setup - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: new server I/O setup
Date
Msg-id alpine.DEB.2.00.1001151714090.6195@aragorn.flymine.org
Whole thread Raw
In response to Re: new server I/O setup  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
Responses Re: new server I/O setup  (Pierre Frédéric Caillaud<lists@peufeu.com>)
List pgsql-performance
On Fri, 15 Jan 2010, Fernando Hevia wrote:
> I was wondering if disabling the bbu cache on the RAID 1 array would make
> any difference. All 256MB would be available for the random I/O on the RAID
> 10.

That would be pretty disastrous, to be honest. The benefit of the cache is
not only that it smooths random access, but it also accelerates fsync. The
whole point of the WAL disc is for it to be able to accept lots of fsyncs
very quickly, and it can't do that without its BBU cache.

Matthew

--
 Heat is work, and work's a curse. All the heat in the universe, it's
 going to cool down, because it can't increase, then there'll be no
 more work, and there'll be perfect peace.      -- Michael Flanders

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: a heavy duty operation on an "unused" table kills my server
Next
From: Alan McKay
Date:
Subject: OT: Db2 connection pooling?