SEO

#1 (**permalink**) 04-09-2008, 11:13 PM

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....111&d=20071204

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-09-2008, 11:13 PM

<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!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#3 (**permalink**) 04-09-2008, 11:15 PM

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. +

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#4 (**permalink**) 04-09-2008, 11:15 PM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

limits