| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | <luca(dot)ciciriello(at)email(dot)it> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, <alessandra(dot)autunno(at)galileoavionica(dot)it> |
| Subject: | Re: limits |
| Date: | 2007-12-04 08:01:53 |
| Message-ID: | 874peysxam.fsf@oxford.xeocode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<luca(dot)ciciriello(at)email(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-12-04 08:14:56 | Re: stored procedures and dynamic queries |
| Previous Message | luca.ciciriello | 2007-12-04 06:55:10 | limits |