> > Howdy! > > > > I'm converting an application to be using postgresql instead of oracle. > > There seems to be only one issue left, batch inserts in postgresql seem > > significant slower than in oracle. I have about 200 batch jobs, each > > consisting of about 14 000 inserts. Each job takes 1.3 seconds in > > postgresql and 0.25 seconds in oracle. With 200 jobs this means several > > more minutes to complete the task. By fixing this I think the > > application using postgresql over all would be faster than when using > > oracle. > > Have you tried COPY statement?
I did that now. I copied all 3 million rows of data into a text file and executed the COPY command. It takes about 0.25 seconds per job. So that's much better. I'm afraid jdbc doesn't support COPY though. But now I know what the theoretical lower limit is atleast. Should it be possible to get anyway nearer 0.25s from my current 1.3s? Tim ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match