Re: COPY threads - Mailing list pgsql-general

From Ravi Krishna
Subject Re: COPY threads
Date
Msg-id B732777C-37FC-484A-A84B-6A7C20D4D2B5@aol.com
Whole thread Raw
In response to Re: COPY threads  (Andres Freund <andres@anarazel.de>)
Responses Re: COPY threads  (Christopher Browne <cbbrowne@gmail.com>)
List 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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: COPY threads
Next
From: Christopher Browne
Date:
Subject: Re: COPY threads