Re: transaction limits? - Mailing list pgsql-general

From Tom Lane
Subject Re: transaction limits?
Date
Msg-id 21125.1129903782@sss.pgh.pa.us
Whole thread Raw
In response to transaction limits?  (jeff sacksteder <jsacksteder@gmail.com>)
List pgsql-general
jeff sacksteder <jsacksteder@gmail.com> writes:
> Are there known limits to how many rows can be inserted by one transaction,
> or does that just reflect the already documented row, table and database
> limits?

Offhand I think the only limit that might concern you is the CID limit
of 2^32 SQL commands per transaction.  This does not directly stop a
single command from processing any number of rows --- but, for example,
if you have a per-row trigger that contains 10 SQL commands, you could
only fire it about 400 million times within one transaction.

            regards, tom lane

pgsql-general by date:

Previous
From: "Wes Williams"
Date:
Subject: Re: password
Next
From: "Magnus Hagander"
Date:
Subject: Re: password