-----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----- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
