Re: Using multi-row technique with COPY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using multi-row technique with COPY
Дата
Msg-id 7456.1133131531@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Using multi-row technique with COPY  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Using multi-row technique with COPY  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Using multi-row technique with COPY  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> COPY FROM can read in sufficient rows until it has a whole block worth
> of data, then get a new block and write it all with one pair of
> BufferLock calls.

> Comments?

I don't see any way to do this without horrible modularity violations.
The COPY code has no business going anywhere near individual buffers;
for that matter, it doesn't even really know what "a block worth" of
data is, since the tuples it's dealing with aren't toasted yet.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Using multi-row technique with COPY
Следующее
От: Michael Fuhr
Дата:
Сообщение: Array comparisons involving NULL