| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: COPY threads |
| Date: | 2018-10-11 20:20:58 |
| Message-ID: | d2e2ddc0-61b2-b021-59a2-214f59569586@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2018-10-11 20:23:21 | Re: something weird happened - can select by column value although column value exist |
| Previous Message | Dmitry O Litvintsev | 2018-10-11 20:17:50 | something weird happened - can select by column value although column value exist |