pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: lantalex (@lantalex) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #3195: Alternative implementation for reWriteBatchedInserts
Date: Fri, 22 Aug 2025 12:43:26 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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
`
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: github://pgjdbc/pgjdbc
Cc: [email protected], [email protected]
Subject: Re: [pgjdbc/pgjdbc] issue #3195: Alternative implementation for reWriteBatchedInserts
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox