pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Max no of commands per transaction
4+ messages / 3 participants
[nested] [flat]

* Max no of commands per transaction
@ 2005-11-22 09:54 Yogvinder Singh <yogvinder@newgen.co.in>
  2005-11-22 12:05 ` Re: Max no of commands per transaction Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Yogvinder Singh @ 2005-11-22 09:54 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Max no of commands per transaction
  2005-11-22 09:54 Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
@ 2005-11-22 12:05 ` Alvaro Herrera <alvherre@commandprompt.com>
  2005-11-22 12:37   ` Re: Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
  0 siblings, 1 reply; 4+ messages in thread

From: Alvaro Herrera @ 2005-11-22 12:05 UTC (permalink / raw)
  To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Max no of commands per transaction
  2005-11-22 09:54 Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
  2005-11-22 12:05 ` Re: Max no of commands per transaction Alvaro Herrera <alvherre@commandprompt.com>
@ 2005-11-22 12:37   ` Yogvinder Singh <yogvinder@newgen.co.in>
  2005-11-22 13:00     ` Re: Max no of commands per transaction Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Yogvinder Singh @ 2005-11-22 12:37 UTC (permalink / raw)
  To: Alvaro Herrera <alvherre@commandprompt.com>

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Max no of commands per transaction
  2005-11-22 09:54 Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
  2005-11-22 12:05 ` Re: Max no of commands per transaction Alvaro Herrera <alvherre@commandprompt.com>
  2005-11-22 12:37   ` Re: Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
@ 2005-11-22 13:00     ` Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2005-11-22 13:00 UTC (permalink / raw)
  To: Yogvinder Singh <yogvinder@newgen.co.in>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-11-22 13:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-22 09:54 Max no of commands per transaction Yogvinder Singh <yogvinder@newgen.co.in>
2005-11-22 12:05 ` Alvaro Herrera <alvherre@commandprompt.com>
2005-11-22 12:37   ` Yogvinder Singh <yogvinder@newgen.co.in>
2005-11-22 13:00     ` Alvaro Herrera <alvherre@alvh.no-ip.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox