[postgis-devel] Lame attempt at cascade union in sql

[Obe, Regina]

Kevin,

Can you try the cascade approach I sent in my last email with your large
dataset.

I tried it with my real data and here are the results 

--time 3328 ms, 3203 ms, 3188 ms
SELECT ST_CascadeUnion(the_geom)
FROM (SELECT * FROM landparcels
WHERE pid lIKE '01%' and the_geom is not null
LIMIT 1000) p

--time 23375 ms, 23594 ms, 24109 ms
SELECT ST_Union(the_geom)
FROM (SELECT * FROM landparcels
WHERE pid lIKE '01%' and the_geom is not null
LIMIT 1000) p
-----------------------------------------
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.