You could do high speed inserts with COPY command:
http://developer.postgresql.org/docs/postgres/sql-copy.html
Check whenether your database adapter/client lib supports it (i guess it
does).
Note that it doesnt help very much if there are fk's/triggers's on the
target table.
Bill Moran wrote:
I must have missed this post when it was made earlier. Pardon the noise if
my suggestion has already been made.
Unlike MySQL (and possibly other database servers) PostgreSQL is faster when
inserting inside a transaction. Depending on the method in which you are
actually adding the records.
In my
