Re: How Many Inserts Per Transactions - Mailing list pgsql-performance

From scott.marlowe
Subject Re: How Many Inserts Per Transactions
Date
Msg-id Pine.LNX.4.33.0308051002010.13157-100000@css120.ihs.com
Whole thread Raw
In response to How Many Inserts Per Transactions  (Trevor Astrope <astrope@e-corp.net>)
List pgsql-performance
On Tue, 5 Aug 2003, Trevor Astrope wrote:

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

I've found that after 1,000 or so inserts, there's no great increase in
speed.


pgsql-performance by date:

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