Skip site navigation (1) Skip section navigation (2)

Re: COPY FROM performance improvements

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Luke Lonergan <llonergan(at)greenplum(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 15:03:28
Message-ID: 42E10AC0.1080905@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-performance
Luke Lonergan wrote:
> Joshua,
> 
> On 7/21/05 7:53 PM, "Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

pgsql-performance by date

Next:From: Madison KellyDate: 2005-07-22 15:09:32
Subject: Solved (was: Re: Another index question)
Previous:From: Sam MasonDate: 2005-07-22 14:51:22
Subject: Re: Planner doesn't look at LIMIT?

pgsql-patches by date

Next:From: Rocco AltierDate: 2005-07-22 16:21:08
Subject: Re: [HACKERS] regressin failure on latest CVS
Previous:From: Stephen FrostDate: 2005-07-22 14:43:05
Subject: Re: [PATCHES] Roles - SET ROLE Updated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group