Re: Begin/Commit - Mailing list pgsql-sql

From Tom Lane
Subject Re: Begin/Commit
Date
Msg-id 16091.1009585573@sss.pgh.pa.us
Whole thread Raw
In response to Begin/Commit  (Linh Luong <linh.luong@computalog.com>)
Responses Re: Begin/Commit
List pgsql-sql
Linh Luong <linh.luong@computalog.com> 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


pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Begin/Commit
Next
From: "Andrew G. Hammond"
Date:
Subject: Re: Multiple counts