Re: COPY FROM performance improvements

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY FROM performance improvements
Date: 2005-06-25 08:20:14
Message-ID: BEE261D0.7CB6%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

I've attached Alon's patch ported to the CVS trunk. It applies cleanly and
passes the regressions. With fsync=false it is 40% faster loading a sample
dataset with 15 columns of varied type. It's 19% faster with fsync=true.

This patch separates the CopyFrom code into two pieces, the new logic for
delimited data and the existing logic for CSV and Binary.

- Luke

Attachment Content-Type Size
fast_copy_patch_V6_lal_ported_8.1.patch application/octet-stream 46.5 KB

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2005-06-25 09:13:10 Re: pl/pgsql: END verbosity
Previous Message Hans-Juergen Schoenig 2005-06-25 06:40:45 Re: Implementing SELECT FOR UPDATE [NOWAIT]