Thread: Max no of commands per transaction

Max no of commands per transaction

From
"Yogvinder Singh"
Date:
hi,
    i am getting an error "ERROR:  You may only have 2^32-1 commands per transaction".
    Can anyone tell where this size 2^32-1 is specified....
    I want to reduce this size...
Thanks in advance
Yogvinder Singh
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unlessthe sender does so expressly with due authority of Newgen Software TechnologiesLtd and / or its subsidiary Companies, as applicable.

Re: Max no of commands per transaction

From
Alvaro Herrera
Date:
Yogvinder Singh wrote:
> hi,
>     i am getting an error "ERROR:  You may only have 2^32-1 commands per transaction".
>     Can anyone tell where this size 2^32-1 is specified....
>     I want to reduce this size...

I doubt you can reduce it without causing problems for the system,
because some commands use more than one "command" internally.  Exactly
what are you planning to do with it?

It would actually be trivial to put a lower limit (see the
CommandCounterIncrement function -- you'll have to recompile), but I
guess I don't see the point.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Re: Max no of commands per transaction

From
Alvaro Herrera
Date:
Yogvinder Singh wrote:
> Atleast i want to know where is this setting for Max no of commands per transaction

There is no setting.  This is not configurable.

Please keep your replies on the list.

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
Al principio era UNIX, y UNIX habló y dijo: "Hello world\n".
No dijo "Hello New Jersey\n", ni "Hello USA\n".

Re: Max no of commands per transaction

From
"Yogvinder Singh"
Date:
Atleast i want to know where is this setting for Max no of commands per transaction


----- Original Message -----
From: "Alvaro Herrera" <alvherre@commandprompt.com>
To: "Yogvinder Singh" <yogvinder@newgen.co.in>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, November 22, 2005 5:35 PM
Subject: Re: [ADMIN] Max no of commands per transaction


> Yogvinder Singh wrote:
> > hi,
> >     i am getting an error "ERROR:  You may only have 2^32-1 commands per transaction".
> >     Can anyone tell where this size 2^32-1 is specified....
> >     I want to reduce this size...
>
> I doubt you can reduce it without causing problems for the system,
> because some commands use more than one "command" internally.  Exactly
> what are you planning to do with it?
>
> It would actually be trivial to put a lower limit (see the
> CommandCounterIncrement function -- you'll have to recompile), but I
> guess I don't see the point.
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>