[OSM-dev] invalid geometry in planet_polygon
Stefan de Konink
stefan at konink.de
Tue Aug 24 16:41:05 BST 2010
-----BEGIN PGP SIGNED MESSAGE-----
Op 24-08-10 17:25, nimix schreef:
>> 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.
> Why not? I think an index like  should work and speed up your queries as
> the validity is only checked once on insert or on the build operation.
> CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree
The index is never used... and how do I know? Because I actually tried it...
-----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