Re: COPY FROM performance improvements

Поиск
Список
Период
Сортировка
От Michael Paesold
Тема Re: COPY FROM performance improvements
Дата
Msg-id 004c01c579d2$4548d020$0f01a8c0@zaphod
обсуждение исходный текст
Ответ на Re: COPY FROM performance improvements  ("Luke Lonergan" <llonergan@greenplum.com>)
Ответы Re: COPY FROM performance improvements  ("Alon Goldshuv" <agoldshuv@greenplum.com>)
Re: COPY FROM performance improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Luke Lonergan wrote:
> 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

What about this one:
    case COPY_OLD_FE:
+    ereport(ERROR,
+      (errcode(ERRCODE_CONNECTION_FAILURE),
+       errmsg("Old FE protocal not yet supported in fast COPY processing
(CopyGetData())")));
+

This can't stay like it is, can it?
Who uses the old FE protocol for COPY? Any drivers?

Otherwise I think the speed improvment is very fine. :-)

Best Regards,
Michael Paesold


В списке pgsql-patches по дате отправления:

Предыдущее
От: "Andrew Dunstan"
Дата:
Сообщение: Re: limiting connections per user/database
Следующее
От: Petr Jelínek
Дата:
Сообщение: Re: limiting connections per user/database