Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9BCDC9FB3A3 for ; Sat, 14 Jul 2007 07:20:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 74370-03 for ; Sat, 14 Jul 2007 07:20:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id EC7F59FB361 for ; Sat, 14 Jul 2007 07:20:44 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 7866A3141A; Sat, 14 Jul 2007 12:20:37 +0200 (MET DST) From: Hannes Dorbath X-Newsgroups: pgsql.performance Subject: Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Date: Sat, 14 Jul 2007 12:19:51 +0200 Organization: Hub.Org Networking Services Lines: 21 Message-ID: <4698A347.2020401@theendofthetunnel.de> References: <1184357777.135345.38110@n60g2000hse.googlegroups.com> <46988951.9050108@theendofthetunnel.de> <87tzs7b93w.fsf@oxford.xeocode.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Gregory Stark User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) In-Reply-To: <87tzs7b93w.fsf@oxford.xeocode.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.27 tagged_above=0 required=5 tests=AWL=0.269, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200707/170 X-Sequence-Number: 25854 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