Message-ID: <gh-pgjdbc-pgjdbc-3195-c3214255763@github.com>
From: "lantalex (@lantalex)" <noreply+lantalex@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 22 Aug 2025 12:43:26 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3195: Alternative implementation for reWriteBatchedInserts
In-Reply-To: <gh-pgjdbc-pgjdbc-3195@github.com>
References: <gh-pgjdbc-pgjdbc-3195@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: lantalex
X-GitHub-Comment-Id: 3214255763
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3195
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3195#issuecomment-3214255763
Content-Type: text/plain; charset=utf-8

Some additional results for batch size = 8192 and total rows = 16384
`Benchmark                           (p1nrows)  (p2multi)  Mode  Cnt      Score     Error  Units
InsertBatch.insertBatch                 16384          1  avgt   10    210.620 ±  15.459  ms/op
InsertBatch.insertBatch                 16384       8192  avgt   10     12.740 ±   0.656  ms/op
InsertBatch.insertBatchWithRewrite      16384          1  avgt   10     13.450 ±   0.949  ms/op
InsertBatch.insertBatchWithRewrite      16384       8192  avgt   10     13.264 ±   0.967  ms/op
InsertBatch.insertCopy                  16384          1  avgt   10  26194.022 ± 277.634  ms/op
InsertBatch.insertCopy                  16384       8192  avgt   10      8.687 ±   1.083  ms/op
InsertBatch.insertExecute               16384          1  avgt   10  24822.447 ± 251.000  ms/op
InsertBatch.insertUnnestArrays          16384          1  avgt   10    194.278 ±  15.689  ms/op
InsertBatch.insertUnnestArrays          16384       8192  avgt   10      9.933 ±   0.173  ms/op
InsertBatch.insertUnnestStruct          16384          1  avgt   10    192.089 ±  27.568  ms/op
InsertBatch.insertUnnestStruct          16384       8192  avgt   10     10.148 ±   0.241  ms/op
`