Skip site navigation (1) Skip section navigation (2)

Re: Performance of jdbc insert statements and select nextval

From: Kris Jurka <books(at)ejurka(dot)com>
To: ralf(dot)baumhof(at)bgs-ag(dot)de
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Performance of jdbc insert statements and select nextval
Date: 2009-02-20 17:41:52
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc

On Fri, 20 Feb 2009, ralf(dot)baumhof(at)bgs-ag(dot)de wrote:

> [insert with pgadmin is faster than JDBC]

As I explained previously I believe pgadmin is sending all of your inserts 
in one network roundtrip rather than a single insert at a time.  So for 

StringBuffer sql = new StringBuffer();
for (int i=0; i<100; i++) {
 	sql.append("INSERT INTO mytable (a) VALUES (");

will be faster than

for (int i=0; i<100; i++) {
 	String sql = "INSERT INTO mytable (a) VALUES (" + i + ")";

because the second sample has to make 100 network trips instead of just 

> I made a test with "logical" insert of objects which results in 50000 
> inserts can be done within 2 minutes, what means 416 inserts per second, 
> or 1 insert in 2/1000 sec (2ms). The cost estimate with explain for an 
> insert is on the other hand is 0,4 ms.

Explain cost estimates do not have units of milliseconds, so the 
comparison is invalid.

Kris Jurka

In response to


pgsql-jdbc by date

Next:From: Maciek SakrejdaDate: 2009-02-20 18:10:59
Subject: Re: COPY support
Previous:From: Kris JurkaDate: 2009-02-20 17:29:39
Subject: Re: SSL - Providing client certificates

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group