How Many Inserts Per Transactions

Trevor Astrope <astrope@e-corp.net>

From: Trevor Astrope <astrope@e-corp.net>
To: pgsql-performance@postgresql.org
Date: 2003-08-05T15:59:11Z
Lists: pgsql-performance
I was wondering if anyone found a sweet spot regarding how many inserts to 
do in a single transaction to get the best performance? Is there an 
approximate number where there isn't any more performance to be had or 
performance may drop off?

It's just a general question...I don't have any specific scenario, other
than there are multiple backends doing many inserts.

Thanks,

Trevor