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 would bloat your > tables considerably ...)
It was a complex plpgsql function iterating through a large volume of data. It would appear that each IF statement in plpgsql is taken as a separate statement because I don't believe I was dealing with more than about 1.2B rows in a FOR ... EXECUTE 'SELECT ...' loop. -- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster