| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY threads |
| Date: | 2018-10-10 19:24:40 |
| Message-ID: | 20181010192440.cdxues44gcvx2sbi@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2018-10-10 19:41:37 | Re: COPY threads |
| Previous Message | Aleš Zelený | 2018-10-10 19:20:31 | Re: tds_fdw binary column |