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