limits
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?
Thanks in advance.
Luca
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Un look da modella in pochi secondi, consigliato da Hunter Tylo
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7111&d=20071204
<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!
luca.ciciriello@email.it wrote:
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?
Yes, there is a command counter that is incremented for every command
between BEGIN and COMMIT. It can't exceed 4 billion commands.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
On Dec 15, 2007, at 8:29 PM, Bruce Momjian wrote:
luca.ciciriello@email.it wrote:
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?Yes, there is a command counter that is incremented for every command
between BEGIN and COMMIT. It can't exceed 4 billion commands.
I think the error message upon hitting that deserves some kind of
easter egg status.
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com