On 3/13/07, femski <[EMAIL PROTECTED]> wrote:
Folks ! 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. I have played with many parameters. Only one that seems to have any affect is fsync - but thats only 10% or so. Initially I got the warning that checkpoints were happening too often so I increased the segments to 24. Warnings stopped, but no real improvement in performance. Is postgres really that slow ? What am I missing ?
how many inserts/sec are you getting approximately. Maybe you have some type of network issue. merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
