Re: Begin/Commit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: linh(dot)luong(at)computalog(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Begin/Commit
Date: 2001-12-29 00:26:13
Message-ID: 16091.1009585573@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Linh Luong <linh(dot)luong(at)computalog(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew G. Hammond 2001-12-29 01:15:26 Re: Multiple counts
Previous Message Dempsey Bullock 2001-12-28 23:54:37 Retrieving information from System Tables