[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-----
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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
-----END PGP SIGNATURE-----
More information about the dev