Re: Restriction on transaction size????

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Ecker <david(at)ecker-software(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restriction on transaction size????
Date: 2003-03-05 15:42:10
Message-ID: 19483.1046878930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Ecker <david(at)ecker-software(dot)de> writes:
> how many querys can be executed inside one transaction??

2^32 - 1.

> It looks like after the commit that 20% of insert querys didn't actually
> got inserted (at 3500 querys in one transaction 2000 select, 1500 insert
> and only ) and the querys are error free.

Dunno what your problem is, but it's not a matter of too many queries.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-03-05 15:47:36 Re: Help me!
Previous Message Jan Wieck 2003-03-05 15:35:18 My employment with PeerDirect