Re: COPY FROM performance improvements - Mailing list pgsql-patches

From Andrew Dunstan
Subject Re: COPY FROM performance improvements
Date
Msg-id 42DD1AE6.6020204@dunslane.net
Whole thread Raw
In response to Re: COPY FROM performance improvements  ("Alon Goldshuv" <agoldshuv@greenplum.com>)
List pgsql-patches

Alon Goldshuv 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.
>
>Patch attached.
>
>
>

I do not have time to review this  2900 line patch analytically, nor to
benchmark it. I have done some functional testing of it on Windows, and
tried to break it in text and CSV modes, and with both Unix and Windows
type line endings - I have not observed any breakage.

This does need lots of eyeballs, though.

cheers

andrew

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch to fix plpython on OS X
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Patch to fix plpython on OS X