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