Re: transaction limits? - Mailing list pgsql-general

From Richard Huxton
Subject Re: transaction limits?
Date
Msg-id 4358BBD8.9030400@archonet.com
Whole thread Raw
In response to transaction limits?  (jeff sacksteder <jsacksteder@gmail.com>)
Responses Re: transaction limits?  (Nicolas Barbier <nicolas.barbier@gmail.com>)
List pgsql-general
jeff sacksteder wrote:
> 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?

Well, the system will need to be able to roll back the transaction, so
at some point your system will grind to a halt. I shouldn't be surprised
if there was some counter that couldn't cope beyond 2^31 rows too but
no-one's found it yet.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Re: doc typo sql-reindex.html psql vs. postgres
Next
From: Johan Wehtje
Date:
Subject: PgInstallerfor 8.1 beta 3 missing Postgis?