[postgis-users] ST_MakeValid

Sandro Santilli strk at keybit.net
Mon Apr 16 09:40:37 PDT 2012


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------'





More information about the postgis-users mailing list