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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Performance of jdbc insert statements and select nextval



i found the following problem:

10000 inserts with pgadmin tool into one table (primary key bigserial) can 
be done wihtin 3 seconds. If i perform the same job with jdbc this takes 
13 seconds. The insert statement is prepared only once, the statement for 
fetching the nextval also. If i omit the select nextval execution time 
improves to 8 seconds. Can anybody tell me why jdbc is  3 to four times 
slower than pgadmin? I am using Postgresql 8.2 and 8.3 Database server, 
java 1.5 and 1.6 and i tried the drivers 8.2 and 8.3 in type 3 and type 4. 
The execution times are always identical. 

thanks, Ralf
BGS Beratungsgesellschaft 
Software Systemplanung AG 
  
  
  
  
Niederlassung Nord 
Ebertstraße 21 
26382 Wilhelmshaven 
Fon: +49 (0) 4421 / 9683-700 
Fax: +49 (0) 4421 / 9683-790 
www.bgs-ag.de 
Geschäftssitz Mainz 
Registergericht 
Amtsgericht Mainz 
HRB 62 50 
  
Aufsichtsratsvorsitzender 
Klaus Hellwig 
Vorstand 
Hanspeter Gau 
Hermann Kiefer 
Nils Manegold 


  


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group