> > 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