Postgres Pro
Downloads
Home   >   mailing lists

Thread: limits

limits

From
luca.ciciriello@email.it
Date:
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

Re: limits

From
Gregory Stark
Date:
<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!

Re: limits

From
Bruce Momjian
Date:
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. +

Re: limits

From
Erik Jones
Date:
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