Re: limits

<luca.ciciriello@email.it> writes:

> Hi All.
> My question is simple and plain: Are there some limit in the number of
> database operations between a BEGIN statement and a COMMIT statement?

The most relevant limitation is that the whole body has to fit in 1GB.

You can also only execute 4 billion statements even if it's in a loop.
8.3 helps this by making most read-only operations not count.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication support!