Re: COPY speedup

Поиск
Список
Период
Сортировка
От Pierre Frédéric Caillaud
Тема Re: COPY speedup
Дата
Msg-id op.uyjjpmdfcke6l8@soyouz
обсуждение исходный текст
Ответ на COPY speedup  (Pierre Frédéric Caillaud<lists@peufeu.com>)
Ответы Re: COPY speedup  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Replying to myself...

I've been examining the code path for COPY FROM too, and I think it is
possible to get the same kind of speedups on COPY FROM that the patch in
the previous message did for COPY TO, that is to say perhaps 2-3x faster
in BINARY mode and 10-20% faster in TEXT mode (these figures are
ballparks, only based on very quick checks however).

The idea is to avoid most (actually, all) palloc()'ing and memcpy()'ing
for types that are pass-by-value like INT.

Is there interest in such a patch (for 8.6) ?


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Table and Index compression
Следующее
От: Pierre Frédéric Caillaud
Дата:
Сообщение: Re: Table and Index compression