How Many Inserts Per Transactions - Mailing list pgsql-performance

From Trevor Astrope
Subject How Many Inserts Per Transactions
Date
Msg-id Pine.LNX.4.44.0308051155100.14944-100000@gord.tabbweb.com
Whole thread Raw
Responses Re: How Many Inserts Per Transactions  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: How Many Inserts Per Transactions  (Hannu Krosing <hannu@tm.ee>)
List 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


pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Some vacuum & tuning help
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Some vacuum & tuning help