I am using Oracle XE so its using only one core and doing just fine. How do I split backend to 4+ processes ? I don't want to write a multithreaded loader app. And I didn't think Postgres can utilize multiple cores for the same insert statement. thanks, -Sanjay On 3/14/07, femski <hypertree@xxxxxxxxx> wrote: when loading to oracle, does it utilize more than one core? istm your best bet would be to split load process to 4+ backends... merlin -- View this message in context: http://www.nabble.com/Postgres-batch-write-very-slow---what-to-do-tf3395195.html#a9486986 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.