Re: COPY FROM performance improvements

Luke Lonergan <llonergan@greenplum.com>

From: "Luke Lonergan" <llonergan@greenplum.com>

To: "Joshua D. Drake" <jd@commandprompt.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-22T04:19:04Z

Lists: pgsql-performance

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?

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