Postgres Pro
Downloads
Home   >   mailing lists

Restriction on transaction size???? - Mailing list pgsql-general

From David Ecker
Subject Restriction on transaction size????
Date
Msg-id 5.1.0.14.2.20030305152202.00ad7a30@pop.puretec.de
Whole thread Raw
Responses Re: Restriction on transaction size????  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: phpBB2 slow on postgres vs mysql ?
Next
From: Tony Grant
Date:
Subject: a date_part question