Re: Multiple Row Insert vs. Batch - Mailing list pgsql-jdbc

I did a benchmark and multi-row insert with a single statement is about 6-7% faster than batch insert. This is for 250 rows executed a thousand times in a loop (alternating between the two to reduce subsequent table insert index slowdown). So a little faster but not significantly so.

On Sat, Jun 6, 2015 at 12:07 PM, Robert DiFalco <robert.difalco@gmail.com> wrote:

Yes that's correct. A multiple row insert with a single insert statement. I'll try benchmarking the two on Monday. My guess is that they are pretty damn similar. 

Sent from my iPhone

On Jun 6, 2015, at 10:35 AM, Dave Cramer <pg@fastcrypt.com> wrote:

Robert ??

Is that what you meant ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 6 June 2015 at 13:34, Vitalii Tymchyshyn <vit@tym.im> wrote:

I think OP meant something like
Insert into table values (?,?,?),(?,?,?),...,(?,?,?);
Vs batch of insert into table values(?,?,?);

I really think first would be faster up to a certain amount of rows, but test is needed to check.

Vitalii Tymchyshyn

Сб, 6 черв. 2015 13:30 Dave Cramer <pg@fastcrypt.com> пише:

batch should be faster and if it isn't we did something wrong

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 6 June 2015 at 12:34, Robert DiFalco <robert.difalco@gmail.com> wrote:

Say I need to insert 250 rows. Is single-statement multiple row insert or JDBC batch likely to be faster?

Thanks!

R.