Re: COPY threads - Mailing list pgsql-general

From Andres Freund
Subject Re: COPY threads
Date
Msg-id 20181010192440.cdxues44gcvx2sbi@alap3.anarazel.de
Whole thread Raw
In response to Re: COPY threads  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: COPY threads  (Rob Sargent <robjsargent@gmail.com>)
Re: COPY threads  (Ravi Krishna <srkrishna1@aol.com>)
List pgsql-general
On 2018-10-10 18:50:02 +0200, Laurenz Albe wrote:
> Rob Sargent wrote:
> > Can anyone here tell me whether or not the CopyManager facility in JDBC 
> > via org.postgresql:postgresql:42.1.4 is internally multithreaded? 
> > Running on CentOS 7 (all participants), java8, postgres 10.5
> 
> It isn't, and there would not be much reason for it to be, as COPY
> in PostgreSQL cannot be parallelized.

s/cannot/is not/.

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.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Aleš Zelený
Date:
Subject: Re: tds_fdw binary column
Next
From: Rob Sargent
Date:
Subject: Re: COPY threads