[postgis-users] Out of memory error with BOX3D

[Jan Saalbach]

Thank you Nicklas. ST_EXTENT3D works fine.

So it is the ST_COLLECT that fetches a complete list of all 17 million 
points which floads the memory. Good to know for later operations.

Regards
Jan


On 20.10.2010 14:50, Nicklas Avén wrote:
>
> Try St_Extent3D instead without st_collect. Then PostGIS can handle 1
> point at a time and not all the 17 millions.
> So try:
> SELECT ST_Extent3D(punkte) FROM rohdaten WHERE id=109;
> ConvexHull is only working in 2D. It will keep the third dimension but
> not include it in the calculations (not 100% sure about that, but almost)
> HTH
> Nicklas
>