[postgis-devel] More Cascade Union Adventures

[Martin Davis]

Ha!  Good stress test... 

OJ fails for me too, after 1 min 30 sec or so.

JTS completes in 22.734 sec.   Keep trying...   8^) 

Obe, Regina wrote:
>
> Try this set.  - this has 2895 records
>
> My timings are
> ---time 161,047 ms = SELECT 161047/1000.0/60 = 2.68 minutes
> SELECT ST_CascadeUnion(the_geom)
> from usstatebounds;
>
> --time 121719 ms = SELECT 121719/1000.0/60 = 2.02 minutes
> SELECT st_unitecascade_garray_sort(ARRAY(SELECT the_geom FROM 
> usstatebounds));
>
> In OJ - it gets to the last round and then fails with a Java out of 
> Heap space error.
>
>
> ------------------------------------------------------------------------
>
> *The substance of this message, including any attachments, may be 
> confidential, legally privileged and/or exempt from disclosure 
> pursuant to Massachusetts law. It is intended solely for the 
> addressee. If you received this in error, please contact the sender 
> and delete the material from any computer. *
>
> ------------------------------------------------------------------------
>
> * Help make the earth a greener place. If at all possible resist 
> printing this email and join us in saving paper. *
>
> * *
>
> * *
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>   

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022