How Many Inserts Per Transactions

From: Trevor Astrope <astrope(at)e-corp(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: How Many Inserts Per Transactions
Date: 2003-08-05 15:59:11
Message-ID: Pine.LNX.4.44.0308051155100.14944-100000@gord.tabbweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew T. O'Connor 2003-08-05 16:01:22 Re: Some vacuum & tuning help
Previous Message Matthew T. O'Connor 2003-08-05 15:45:04 Re: Some vacuum & tuning help