Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 22:30 +0100, Tino Wildenhain wrote: > Rod Taylor schrieb: > > On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > > > >>Rod Taylor wrote: > >> > >>>Is there any way of bumping this limit or am I stuck breaking up the > >>>transaction? > >> > >>Wow, I never heard of any

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tino Wildenhain
Rod Taylor schrieb: > On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > >>Rod Taylor wrote: >> >>>Is there any way of bumping this limit or am I stuck breaking up the >>>transaction? >> >>Wow, I never heard of anyone reaching the limit :-( Sorry, you are >>stuck (short of changing Comman

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > Does a subtransaction receive an independent command counter? No such luck, and IIRC that would not be easy at all to change :-( regards, tom lane ---(end of broadcast)--- TIP 6: expl

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Would it be possible to increment the command counter only for commands > that do updates? Probably that would work, but I'm unsure whether we have infrastructure that would let you detect that reliably... regards, tom lane

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > Rod Taylor wrote: > > Is there any way of bumping this limit or am I stuck breaking up the > > transaction? > > Wow, I never heard of anyone reaching the limit :-( Sorry, you are > stuck (short of changing CommandId to 64 bits, which woul

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Heikki Linnakangas
On Sat, 21 Jan 2006, Alvaro Herrera wrote: Rod Taylor wrote: Is there any way of bumping this limit or am I stuck breaking up the transaction? Wow, I never heard of anyone reaching the limit :-( Sorry, you are stuck (short of changing CommandId to 64 bits, which would bloat your tables consi

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Alvaro Herrera
Rod Taylor wrote: > Is there any way of bumping this limit or am I stuck breaking up the > transaction? Wow, I never heard of anyone reaching the limit :-( Sorry, you are stuck (short of changing CommandId to 64 bits, which would bloat your tables considerably ...) -- Alvaro Herrera

Re: [HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
On Sat, 2006-01-21 at 12:48 -0300, Alvaro Herrera wrote: > Rod Taylor wrote: > > Is there any way of bumping this limit or am I stuck breaking up the > > transaction? > > Wow, I never heard of anyone reaching the limit :-( Sorry, you are > stuck (short of changing CommandId to 64 bits, which woul

[HACKERS] Commands per transaction

2006-01-21 Thread Rod Taylor
Is there any way of bumping this limit or am I stuck breaking up the transaction? ERROR: cannot have more than 2^32-1 commands in a transaction -- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings