On 3/13/07, femski <[EMAIL PROTECTED]> wrote:
I have a batch application that writes approx. 4 million rows into a narrow table. I am using JDBC addBatch/ExecuteBatch with auto commit turned off. Batch size is 100. So far I am seeing Postgres take roughly five times the time it takes to do this in the Oracle.
you can try to use pg_bulkload. since it is called as standard function you shouldn't have problems with jdbc. and it's apparently fast. depesz http://pgfoundry.org/projects/pgbulkload/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
