<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 10/03/2022 04.08, Vladimir Sitnikov
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAB=Je-G7Xa9KR_sMYuO7TKOURjT7wQ7rdbn-k0trSebMNaaYhg(at)mail(dot)gmail(dot)com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"><br>
<div>Have you tried PreparedStatement#addBatch + #executeBatch
APIs and reWriteBatchedInserts=true connection option?</div>
<div>It might yield the expected speedup without resorting to
PG-specific APIs and syntax like COPY.</div>
<br>
</div>
</blockquote>
<br>
Yes, I tried addBatch + executeBatch. It was very inconvenient in my
specific case. I used all over the place postgresql extension<br>
<br>
insert into table(c1, c2, c3, ...) values (....) RETURNING *<br>
<br>
this way I can "get back" the data inserted. The PG extension
INSERT/UPDATE/DELETE ... RETURNING *<br>
was so convenient to: 1. check the data, 2. autoincrements, 3.
Return updated data, etc, that I started to use in with almost all
insert/update/delete.<br>
The #executeBatch returns the number of rows changed, not the data
as with the RETURNING *<br>
<br>
Vladislav <font size="+1"><br>
</font>
</body>
</html>