Re: COPY FROM performance improvements

Luke Lonergan <llonergan@greenplum.com>

From: "Luke Lonergan" <llonergan@greenplum.com>
To: "PostgreSQL-patches" <pgsql-patches@postgresql.org>
Date: 2005-08-07T03:25:24Z
Lists: pgsql-performance

Attachments

Tom,

My direct e-mails to you are apparently blocked, so I'll send this to the
list.

I've attached the case we use for load performance testing, with the data
generator modified to produce a single row version of the dataset.

I do believe that you/we will need to invert the processing loop to get the
maximum parsing speed.  We will be implementing much higher loading speeds
which require it to compete with Oracle, Netezza, Teradata, so we'll have to
work this out for the best interests of our users.

- Luke