Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 - Mailing list pgsql-performance

From Hannes Dorbath
Subject Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
Date
Msg-id 4698A347.2020401@theendofthetunnel.de
Whole thread Raw
In response to Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
List pgsql-performance
Gregory Stark wrote:
>> From the DELL site it seems this `PERC 5/i' on board controller
>> (assuming that's what you have) doesn't even have a BBU. If you don't
>> plan to post here in a few weeks again about data corruption, go out and
>> shop a serious controller.
>
> This is a bit of a strange comment. A BBU will improve performance but
> Postgres doesn't require one to guarantee data integrity.
>
> If your drives have write caching disabled (ie write-through) and your
> controller does write-through caching and you leave fsync=on and
> full_page_writes=on which is the default then you shouldn't have any data
> integrity issues.

That was my point, controllers without BBU usually leave drive caches
turned on, as with drive caches off performance would be unbearable bad.


--
Best regards,
Hannes Dorbath

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950
Next
From: Patric de Waha
Date:
Subject: Vacuum full considered useful ;)