X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3DE4952BBD for ; Thu, 21 Jul 2005 23:05:12 -0300 (ADT) 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 20073-03 for ; Fri, 22 Jul 2005 02:05:01 +0000 (GMT) Received: from mail.Mi8.com (mail.mi8.com [63.240.6.50]) by svr1.postgresql.org (Postfix) with ESMTP id 80AD0529E9 for ; Thu, 21 Jul 2005 23:04:59 -0300 (ADT) Received: from 172.16.1.118 by mail.Mi8.com with ESMTP (- GW05 Welcome to Mi8 Corporation www.Mi8.com); Thu, 21 Jul 2005 22:04:57 -0400 X-Server-Uuid: E0C866E6-C6CD-48B5-AE61-E57E73CF3CC7 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by d01smtp03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 21 Jul 2005 22:04:57 -0400 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Thu, 21 Jul 2005 22:04:56 -0500 User-Agent: Microsoft-Entourage/11.1.0.040913 Date: Thu, 21 Jul 2005 19:04:55 -0700 Subject: Re: COPY FROM performance improvements From: "Luke Lonergan" To: "Joshua D. Drake" Cc: "Mark Wong" , "Andrew Dunstan" , "Alvaro Herrera" , "Bruce Momjian" , "Alon Goldshuv" , pgsql-patches@postgresql.org, maryedie@osdl.org Message-ID: In-Reply-To: <42E038E9.1080107@commandprompt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 22 Jul 2005 02:04:57.0229 (UTC) FILETIME=[C2465BD0:01C58E61] X-WSS-ID: 6EFE8BC31M89611019-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.574 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200507/427 X-Sequence-Number: 16767 Joshua, On 7/21/05 5:08 PM, "Joshua D. Drake" wrote: > O.k. this strikes me as interesting, now we know that Compaq and Dell > are borked for Linux. Is there a name brand server (read Enterprise) > that actually does provide reasonable performance? I think late model Dell (post the bad chipset problem, circa 2001-2?) and IBM and Sun servers are fine because they all use simple SCSI adapters from LSI or Adaptec. The HP Smartarray is an aberration, they don't have good driver support for Linux and as a consequence have some pretty bad problems with both performance and stability. On Windows they perform quite well. Also - there are very big issues with some SATA controllers and Linux we've seen, particularly the Silicon Image, Highpoint other non-Intel controllers. Not sure about Nvidia, but the only ones I trust now are 3Ware and the others mentioned in earlier posts. - Luke