Re: limits - Mailing list pgsql-general

From Gregory Stark
Subject Re: limits
Date
Msg-id 874peysxam.fsf@oxford.xeocode.com
Whole thread Raw
In response to limits  (luca.ciciriello@email.it)
List pgsql-general
<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!

pgsql-general by date:

Previous
From: luca.ciciriello@email.it
Date:
Subject: limits
Next
From: Richard Huxton
Date:
Subject: Re: stored procedures and dynamic queries