On Mon, Apr 16, 2012 at 12:33:15PM -0400, Stephen V. Mather wrote: > Then a quick run through cleanGeometry: ... > Query returned successfully: 1004952 rows affected, 955444 ms execution time. > > If I run as ST_MakeValid, ... > At 2300000 milliseconds, it is still running. .
The ST_MakeValid tries its best to retain all input vertices. IIRC there's a difference with a multipolygon composed by two overlapping rectangles. Also, ST_MakeValid internally checks for input validity and avoids running anything if the input is valid. Such check has a cost too. --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
