[postgis-users] ERROR: array size exceeds the maximum allowed (134217727)

[strk]

On Sat, Mar 20, 2010 at 05:49:42AM -0400, Mike Leahy wrote:
> Hello again,
> 
> It might be of interest to point out that substituting st_union() with 
> st_memunion() seems to have worked around this.  I'm curious though, because 
> there is not a great deal of data being processed, and I am running this on a 
> fairly sturdy system that that has more capacity than some of the Fedora 
> systems I'm running.

st_memunion builds a big array with all geometries in it..
you were hitting a limit of the array type.
st_union should behave better.

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html