Re: COPY FROM performance improvements

From: Mark Wong <markw(at)osdl(dot)org>
To: "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY FROM performance improvements
Date: 2005-07-19 19:54:53
Message-ID: 200507191954.j6JJsVjA003280@smtp.osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-performance

On Thu, 14 Jul 2005 17:22:18 -0700
"Alon Goldshuv" <agoldshuv(at)greenplum(dot)com> wrote:

> I revisited my patch and removed the code duplications that were there, and
> added support for CSV with buffered input, so CSV now runs faster too
> (although it is not as optimized as the TEXT format parsing). So now
> TEXT,CSV and BINARY are all parsed in CopyFrom(), like in the original file.

Hi Alon,

I'm curious, what kind of system are you testing this on? I'm trying to
load 100GB of data in our dbt3 workload on a 4-way itanium2. I'm
interested in the results you would expect.

Mark

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Jim C. Nasby 2005-07-19 20:11:35 Re: [HACKERS] Patch to fix plpython on OS X
Previous Message Michael Fuhr 2005-07-19 19:54:00 Re: Patch to fix plpython on OS X

Browse pgsql-performance by date

  From Date Subject
Next Message Oliver Crosby 2005-07-19 20:08:11 Re: Looking for tips
Previous Message Jeff Trout 2005-07-19 19:53:04 Re: Looking for tips