<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'><div dir='ltr'>
Thanks for the responses. Have changed the original query from this:<BR> <BR>SELECT ST_ConvexHull(ST_Collect(ST_Force_2D(geom))) FROM table001<BR> <BR>to this:<BR> <BR>SELECT ST_ConvexHull(ST_MemUnion(geom)) FROM table001<BR> <BR>and its still running; over 12 hours now.<BR>Is this a waste of time.<BR>I'm trying it this way as I guessed it could be an aggregate approach issue after reading this post from Paul:<BR> <BR><a href="http://blog.cleverelephant.ca/2009/01/must-faster-unions-in-postgis-14.html">http://blog.cleverelephant.ca/2009/01/must-faster-unions-in-postgis-14.html</a><BR> <BR>and was wondering if the union operation might work for my current requirements so set it running yesterday. <BR>The ST_Union gives the same array size error after a few seconds but as I said the ST_MemUnion is still running, but is it working or going to work!!!<BR> <BR>Anyway, thanks again for your feedback.<BR> <BR>Paul<BR><br> <BR> </div></body>
</html>