Restriction on transaction size????

From: David Ecker <david(at)ecker-software(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Restriction on transaction size????
Date: 2003-03-05 14:40:10
Message-ID: 5.1.0.14.2.20030305152202.00ad7a30@pop.puretec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-03-05 14:41:37 Re: Mailing lists still points to a non-existent page
Previous Message Jan Wieck 2003-03-05 14:39:49 My employment with PeerDirect (version 3)