From: Joshua D. Drake <jd@commandprompt.com>
To: Luke Lonergan <llonergan@greenplum.com>
Cc: Mark Wong <markw@osdl.org>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Alvaro Herrera <alvherre@surnet.cl>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Alon Goldshuv <agoldshuv@greenplum.com>
Cc: pgsql-patches@postgresql.org
Cc: maryedie@osdl.org
Subject: Re: COPY FROM performance improvements
Date: Thu, 21 Jul 2005 19:53:35 -0700
Message-ID: <42E05FAF.70601@commandprompt.com> (raw)
In-Reply-To: <BF05A257.96F2%llonergan@greenplum.com>
References: <BF05A257.96F2%llonergan@greenplum.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, llonergan@greenplum.com, markw@osdl.org, andrew@dunslane.net, alvherre@surnet.cl, pgman@candle.pha.pa.us, agoldshuv@greenplum.com, pgsql-patches@postgresql.org, maryedie@osdl.org
Subject: Re: COPY FROM performance improvements
In-Reply-To: <42E05FAF.70601@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox