Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBT0QRm33254 for ; Fri, 28 Dec 2001 19:26:27 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fBT0QEg16094; Fri, 28 Dec 2001 19:26:14 -0500 (EST) To: linh.luong@computalog.com cc: pgsql-sql@postgresql.org Subject: Re: Begin/Commit In-reply-to: <20011228222730.555C0197395@jamie.edmonton.computalog.com> References: <20011228222730.555C0197395@jamie.edmonton.computalog.com> Comments: In-reply-to Linh Luong message dated "Fri, 28 Dec 2001 15:27:29 -0700" Date: Fri, 28 Dec 2001 19:26:13 -0500 Message-ID: <16091.1009585573@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200112/256 X-Sequence-Number: 6078 Linh Luong writes: > I was wondering is there a limitation in the number of sql stmt that can go > between a begin and commit. No, not as such. If you are doing operations that involve foreign-key checks, you may see performance problems in pre-7.2 releases due to some operations that walk the list of pending foreign-key triggers. You didn't give enough info to know if that is a problem, though. regards, tom lane