Re: COPY threads - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: COPY threads
Date
Msg-id d2e2ddc0-61b2-b021-59a2-214f59569586@gmx.net
Whole thread Raw
In response to COPY threads  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Rob Sargent schrieb am 10.10.2018 um 00:45:> 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

An alternative to creating your own multi-threaded importer, might be to use pgLoader which supports that out of the
box:

https://pgloader.readthedocs.io/en/latest/pgloader.html#a-note-about-parallelism

I have never used it though, but heard good things about it.


pgsql-general by date:

Previous
From: Dmitry O Litvintsev
Date:
Subject: something weird happened - can select by column value although columnvalue exist
Next
From: Ron
Date:
Subject: Re: something weird happened - can select by column value althoughcolumn value exist