Обсуждение: copyManager Implementation :: in postgreSQL community Driver
Hi All,
there is a copyManager() implementation in community version JDBC driver.
From what I understand from client end, we provide the file as a fileReader and pass it on to the copyManager() instance.
I see the performance of this copyManager is not comparable to PSQL command line copy. Hence I wanted to know how differently is copyManager is implemented?
does copyManager implement the copy command (in server) for the whole file or, it does convert the file data into batches and implement copy command ?
Regards
Yogi
On 07/23/2018 02:11 AM, Yogi S wrote: > Hi All, > there is a copyManager() implementation in community version JDBC driver. > From what I understand from client end, we provide the file as a > fileReader and pass it on to the copyManager() instance. > > I see the performance of this copyManager is not comparable to PSQL > command line copy. Hence I wanted to know how differently is copyManager > is implemented? Where did you see this? From here: https://jdbc.postgresql.org/documentation/publicapi/index.html it looks like it uses COPY. > > does copyManager implement the copy command (/in server/) for the whole > file or, it does convert the file data into batches and implement copy > command ? From above link looks like you have your choice of using a Reader or InputStream and setting a buffer size for each. > > Regards > Yogi -- Adrian Klaver adrian.klaver@aklaver.com