Message-ID: <42E05FAF.70601@commandprompt.com>
Date: Thu, 21 Jul 2005 19:53:35 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404)
MIME-Version: 1.0
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Mark Wong <markw@osdl.org>, Andrew Dunstan <andrew@dunslane.net>,
	Alvaro Herrera <alvherre@surnet.cl>,
	Bruce Momjian <pgman@candle.pha.pa.us>,
	Alon Goldshuv <agoldshuv@greenplum.com>,
	pgsql-patches@postgresql.org, maryedie@osdl.org
Subject: Re: COPY FROM performance improvements
References: <BF05A257.96F2%llonergan@greenplum.com>
In-Reply-To: <BF05A257.96F2%llonergan@greenplum.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


> 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.

Well I know that isn't true at least not with ANY of the Dells my 
customers have purchased in the last 18 months. They are still really, 
really slow.

> 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.

I have great success with Silicon Image as long as I am running them 
with Linux software RAID. The LSI controllers are also really nice.

J


> 
> - Luke
> 
>  
> 


-- 
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org