X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B2C3B53947 for ; Tue, 29 Mar 2005 00:38:06 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17634-09 for ; Mon, 28 Mar 2005 23:38:04 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [64.139.89.126]) by svr1.postgresql.org (Postfix) with ESMTP id 155D253806 for ; Tue, 29 Mar 2005 00:38:03 +0100 (BST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id j2SNbsH03747; Mon, 28 Mar 2005 18:37:54 -0500 (EST) From: Bruce Momjian Message-Id: <200503282337.j2SNbsH03747@candle.pha.pa.us> Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? In-Reply-To: <87wtrr1mih.fsf@stark.xeocode.com> To: Greg Stark Date: Mon, 28 Mar 2005 18:37:54 -0500 (EST) Cc: jd@commandprompt.com, Merlin Moncure , alex@neteconomist.com, pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.011 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/619 X-Sequence-Number: 11324 Greg Stark wrote: > "Joshua D. Drake" writes: > > > > I assume AMCC == 3ware now? > > > > > > Has anyone verified that fsync is safe on these controllers? Ie, that they > > > aren't caching writes and "lying" about the write completing like IDE > > > drives often do by default? > > > > The higher end AMCC/3ware controllers actually warn you about using > > write-cache. You have to explicitly turn it on within the controller > > bios. > > Well that's a good sign. > > But if they're using SATA drives my concern is that the drives themselves may > be doing some caching on their own. Has anyone verified that the controllers > are disabling the drive cache or issuing flushes or doing something else to be > sure to block the drives from caching writes? I asked 3ware this at the Linuxworld Boston show and they said their controller keeps the information in cache until they are sure it is on the platters and not just in the disk cache, but that is far from a 100% reliable report. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073