> > Well, I just did an insert of 27,500 records with 9 fields, averaging 
> > around 118 bytes per record, each insert statement coming from a separate 
> > SQL statement fed to psql, and it took a bit over 4 minutes, or about 
> > 106 inserts per second.
> Is that with a separate transaction for each insert command?  I can get
> significantly higher rates on my devel machine if the inserts are
> bundled into transactions of reasonable length.

That's with autocommit on.  If I do it as a single transaction block,
it takes about 6.5 seconds, which is about 4200 transactions/second.
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to