-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 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 [1] should work and speed up your queries as > the validity is only checked once on insert or on the build operation. > regards, > Melchior > > [1] > CREATE INDEX idx_planet_osm_polygon_valid ON planet_osm_polygon USING btree > (ST_IsValid(way));
The index is never used... and how do I know? Because I actually tried it... Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAkxz6BEACgkQYH1+F2Rqwn1zMwCcC26BVrL9Ol5tQSWI1kjZOe5Z zsEAnR/QiZOsWTLdm9OApngAqaZXUjFn =sfSo -----END PGP SIGNATURE----- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
