Re: COPY FROM performance improvements

From: "Alon Goldshuv" <agoldshuv(at)greenplum(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: COPY FROM performance improvements
Date: 2005-07-15 00:22:18
Message-ID: BEFC4FCB.7017%agoldshuv@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-performance

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.

Patch attached.

Greetings,
Alon.

Attachment Content-Type Size
copy_parse_improvements_V15.patch application/octet-stream 78.0 KB

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2005-07-15 00:47:09 Re: Final cleanup of SQL:1999 references
Previous Message Titus von Boxberg 2005-07-14 22:26:43 Re: PL/PGSQL: Dynamic Record Introspection

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-15 00:28:24 Re: lots of updates on small table
Previous Message Dan Harris 2005-07-15 00:12:07 Re: slow joining very large table to smaller ones