Re: [GENERAL] transaction limits?

2005-10-21 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > MaXX <[EMAIL PROTECTED]> writes: >> An error string in the source code stands: >> "cannot have more than 2^32-1 commands in a transaction" > That means you couldn't do more than 2^32-1 INSERT statements. Right. > But that wouldn't (in principle) prevent

Re: [GENERAL] transaction limits?

2005-10-21 Thread Chris Browne
MaXX <[EMAIL PROTECTED]> writes: > 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? > An error string in the source code stands: > "cannot have more

Re: [GENERAL] transaction limits?

2005-10-21 Thread Tom Lane
jeff sacksteder <[EMAIL PROTECTED]> 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

Re: [GENERAL] transaction limits?

2005-10-21 Thread MaXX
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? An error string in the source code stands: "cannot have more than 2^32-1 commands in a transaction" (#:

Re: [GENERAL] transaction limits?

2005-10-21 Thread Richard Huxton
Nicolas Barbier wrote: On 10/21/05, Richard Huxton wrote: 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

Re: [GENERAL] transaction limits?

2005-10-21 Thread Mark Rae
On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote: > On 10/21/05, Richard Huxton wrote: > > jeff sacksteder wrote: > > > Are there known limits to how many rows can be inserted by one > > > transaction, > > > Well, the system will need to be able to roll back the transaction, ... >

Re: [GENERAL] transaction limits?

2005-10-21 Thread Nicolas Barbier
On 10/21/05, Richard Huxton wrote: > 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 transac

Re: [GENERAL] transaction limits?

2005-10-21 Thread Richard Huxton
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 h

[GENERAL] transaction limits?

2005-10-21 Thread jeff sacksteder
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?