how many inserts in one transaction?

From: gav <gav(at)nlr(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: how many inserts in one transaction?
Date: 2000-01-22 21:15:52
Message-ID: 1611.000123@nlr.ru
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-sql

Hi,

I have a database created in postgres 6.5.3 and need insert huge
number (~10-100 thousands) of
rows in one of tables. To do that quickly I put this part of work in
transaction. My question is such: should I split this block of
insertings into many transaction to raise the speed? And
exists the limit of INSERT-commands that I can do in one transaction?

Best regards,
Alex

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-22 21:43:40 Re: [SQL] More efficient DELETE ... ?
Previous Message Bruce Momjian 2000-01-22 19:37:39 Re: [SQL] More efficient DELETE ... ?