Hi, Try using parametrized prepared statements, does that make a difference? Or does PGSQL jdbc not support them in your version?
--Tim -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Kleiser Sent: Wednesday, November 10, 2004 2:52 PM To: Jeff Cc: Shane|SkinnyCorp; [EMAIL PROTECTED] Subject: [PERFORM] How to speed-up inserts with jdbc [...] > Statement st = con.createStatement(); [...] st.executeUpdate("insert into history(uuid,coni,date,direction,partner,type) values('uuid','content','"+datum+"','dir','partner','type')"); [...] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend