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

From Tom Lane
Subject Re: COPY FROM performance improvements
Date
Msg-id 3251.1119742028@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY FROM performance improvements  ("Alon Goldshuv" <agoldshuv@greenplum.com>)
Responses Re: COPY FROM performance improvements  ("Alon Goldshuv" <agoldshuv@greenplum.com>)
Re: COPY FROM performance improvements  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-patches
"Alon Goldshuv" <agoldshuv@greenplum.com> writes:
> A struct "bytebuffer" is used instead of a StringInfoData for storing the
> line and attributes. A StringInfoData is actually really cool and useful,
> but we don't really need it's formatting capabilities in COPY FROM (as far
> as I know), and so the bytebuffer is more straightfoward and faster.

Is it really faster than appendStringInfoString or
appendBinaryStringInfo?

            regards, tom lane

pgsql-patches by date:

Previous
From: Petr Jelínek
Date:
Subject: Re: limiting connections per user/database
Next
From: Tom Lane
Date:
Subject: Re: limiting connections per user/database