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-22T15:03:28Z
Lists: pgsql-performance 
Luke Lonergan wrote:
> Joshua,
> 
> On 7/21/05 7:53 PM, "Joshua D. Drake" <jd@commandprompt.com> wrote:
> 
>>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.
> 
> 
> That's too bad, can you cite some model numbers?  SCSI?

Yeah I will get them and post, but yes they are all SCSI.

> 
> 
>>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.
> 
> 
> That's good to hear, I gave up on Silicon Image controllers on Linux about 1
> year ago, which kernel are you using with success?

Any of the 2.6 kernels. ALso the laster 2.4 (+22 I believe) support it 
pretty well as well.

   Silicon Image
> controllers are the most popular, so it's important to see them supported
> well, though I'd rather see more SATA headers than 2 off of the built-in
> chipsets. 
> 
> - 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