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
Re: Using multi-row technique with COPY |
| Список | 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 по дате отправления: