Are there limits to number of INSERTS inside a Transaction?

From: Ken Causey <ken(at)premiernet(dot)net>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Are there limits to number of INSERTS inside a Transaction?
Date: 2000-07-12 16:02:33
Message-ID: 3.0.1.32.20000712110233.018aa928@premiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I can tell this is going to be a good day, it's my second stupid question
of the day. Thanks to Alex Bolenok for a complete, concise answer to my
first question!

Now the question: Can I do too much inside a transaction? In other
words, say I was importing a file with 100,000 records and I wanted
to make sure either the whole thing imported or none of it; would it
be a bad idea to do ALL of the inserts within a single transaction?

Are there any limits to the number of inserts/updates within a transaction?

Ken Causey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Jaynes 2000-07-12 16:16:27 Re: How to remove a user ?
Previous Message Tomas B. Winkler 2000-07-12 15:33:30 listen/notify