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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster