Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group