I've seen some concerns about buying database performance hardware
from DELL. Are there at least some of the RAID cards that work well
with Linux or should I stay clear of DELL permanently?
25 jun 2008 kl. 17.45 skrev Greg Smith:
> On Wed, 25 Jun 2008, Henrik wrote:
>> Would you turn off fsync if you had a controller with BBU? =)
> Turning off fsync has some potential to introduce problems even in
> that environment, so better not to do that. The issue is that you
> might have, say, 1GB of OS-level cache but 256MB of BBU cache, and
> if you turn fsync off it won't force the OS cache out to the
> controller when it's supposed to and that can cause corruption.
> Also, if you've got a controller with BBU, the overhead of fsync for
> regular writes is low enough that you don't really need to turn it
> off. If writes are cached the fsync is almost free.
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com
> Baltimore, MD
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org
> To make changes to your subscription:
In response to
pgsql-performance by date
|Next:||From: Vivek Khera||Date: 2008-06-26 13:43:03|
|Subject: Re: Hardware vs Software RAID|
|Previous:||From: Craig Ringer||Date: 2008-06-26 13:16:25|
|Subject: Re: ??: Postgresql update op is very very slow|