"Rahul_Iyer" <[EMAIL PROTECTED]> writes: > im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts > into a 2 column table (one col=integer, 2nd col=character). I used the > Prepare... and execute method, so i basically had 5M execute statements and > 1 prepare statement. Postgres took 144min for this... is there any way to > improve this performance?
COPY, perhaps. Have you read http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=populate.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
