Thread: Restriction on transaction size????

Hi,

how many querys can be executed inside one transaction??

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.

Executing each query as one transaction, everything seems to work fine.

thx
David Ecker


PS. I am running version 7.2.1 on cygwin/win32

David Ecker <david@ecker-software.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