[OSM-dev] invalid geometry in planet_polygon

Stefan de Konink stefan at konink.de
Tue Aug 24 12:31:14 BST 2010


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Op 24-08-10 13:17, Mike N. schreef:
> 
>> ST_IsValid is a relatively expensive operation, so be careful with
>> that. If you are using it a lot, it might be worthfile to just delete
>> invalid geometries once.
> 
>  I've measured the speed difference at about 8X to use ST_IsValid .

It is really a bitch that PostgreSQL cannot use the ST_IsValid as index
in queries. Yes, you could manually do the boolean operation yourself,
but still it would be quite handy if the validness wouldn't be checked
at all if it was valid in the first place.


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkxzrYIACgkQYH1+F2Rqwn25zgCfTUxyyde81k3iK7n0SiiTqctR
LO0AnA2bDApYGqN6G6pvqfb9RqcFWSbV
=Vbdb
-----END PGP SIGNATURE-----



More information about the dev mailing list