Обсуждение: 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