Re: COPY FROM performance improvements

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Mark Wong" <markw(at)osdl(dot)org>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Alvaro Herrera" <alvherre(at)surnet(dot)cl>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>, pgsql-patches(at)postgresql(dot)org, maryedie(at)osdl(dot)org
Subject: Re: COPY FROM performance improvements
Date: 2005-07-22 02:04:55
Message-ID: BF05A257.96F2%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-performance

Joshua,

On 7/21/05 5:08 PM, "Joshua D. Drake" <jd(at)commandprompt(dot)com> 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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Stephen Frost 2005-07-22 02:38:56 Re: [PATCHES] Roles - SET ROLE Updated
Previous Message Joshua D. Drake 2005-07-22 00:08:09 Re: COPY FROM performance improvements

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2005-07-22 02:53:35 Re: COPY FROM performance improvements
Previous Message Josh Berkus 2005-07-22 00:26:03 Re: What is best way to stream terabytes of data into postgresql?