Skip site navigation (1) Skip section navigation (2)

Re: Hardware suggestions for high performance 8.3

From: Henrik <henke(at)mac(dot)se>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware suggestions for high performance 8.3
Date: 2008-06-26 13:35:34
Message-ID: E8D1FB0E-93EE-42D4-BD06-19CB87E21494@mac.se (view raw or flat)
Thread:
Lists: pgsql-performance
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?

Thanks!

//Henke
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:
> http://www.postgresql.org/mailpref/pgsql-performance


In response to

Responses

pgsql-performance by date

Next:From: Vivek KheraDate: 2008-06-26 13:43:03
Subject: Re: Hardware vs Software RAID
Previous:From: Craig RingerDate: 2008-06-26 13:16:25
Subject: Re: ??: Postgresql update op is very very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group