Postgres Pro
Downloads
Home   >   mailing lists

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

From Vitalii Tymchyshyn
Subject Re: Multiple Row Insert vs. Batch
Date
Msg-id CABWW-d1=T9jUQu+7wdc62vzuQ20Wkw2nRcXJcyXQK9pGPdZZHg@mail.gmail.com
Whole thread Raw
In response to Re: Multiple Row Insert vs. Batch  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Multiple Row Insert vs. Batch  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view

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.

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Multiple Row Insert vs. Batch
Next
From: Dave Cramer
Date:
Subject: Re: Multiple Row Insert vs. Batch