Hi All,
The following error has me lost as to finding the solution:
*****************************************************************************
ERROR: array size exceeds the maximum allowed (1073741823)
---------- Error----------------
ERROR: array size exceeds the maximum allowed (1073741823)
SQL state: 54000
*****************************************************************************
It happened when using this SQL:
*****************************************************************************
SELECT ST_ConvexHull(ST_Collect(ST_Force_2D(geom))) FROM table001
*****************************************************************************
This table has 62 million 3D point geometry records, which is one of the small
tables I want to use this function on.
While the server we are running is quite powerful (32GB RAM), we have edited a
lot of system/DB memory settings but I cannot trace any changes we made to the
array size mentioned in the error.
It also seems this query is very similar to this thread:
http://postgis.refractions.net/pipermail/postgis-users/2010-March/026215.html
However, I cannot ascertain if a solution was found in this thread and was
wondering if anyone has seen this problem.
The error's array size is 1GB I believe (if the number is bytes) but we have
not changed any settings that reference 1GB, does anyone know where this array
limit error is coming from. I have a similar system to that mentioned in the
thread above but for a Postgresql 9 install. The DB is fine other than this
error where more complex bounding box queries on the 3D geoms are working.
Any help/info would be much appreciated.
Paul
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
