Horton

Re: COPY FROM performance improvements

Joshua D. Drake <jd@commandprompt.com>

View thread View on postgr.es
From: "Joshua D. Drake" <jd@commandprompt.com>
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
Date: 2005-07-22T02:53:35Z
Lists: pgsql-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.

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