Re: COPY threads

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: COPY threads
Дата
Msg-id B732777C-37FC-484A-A84B-6A7C20D4D2B5@aol.com
обсуждение исходный текст
Ответ на Re: COPY threads  (Andres Freund <andres@anarazel.de>)
Ответы Re: COPY threads
Список pgsql-general
>
> You obviously can just copy the data into postgres over multiple
> connections if you need to speed COPY up. But that requires splitting up
> the data on the clientside.
>

You obviously are referring to multiple connections running COPY on different tables, right?  Like what pg_restore does
with-j option. 
Doesn't copy take an exclusive lock on the table which makes it incompatible with parallelization.



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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: COPY threads
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: COPY threads