[OSM-dev] invalid geometry in planet_polygon

Stefan de Konink stefan at konink.de
Tue Aug 24 17:42:15 BST 2010


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

Op 24-08-10 18:37, nimix schreef:
> Your right if you want to do a ... WHERE St_IsValid(geom) query, the planner
> don't uses the index because 99% of geometries are valid, so an index scan
> seems to be useless. In that case I made postgres use the index by double
> negation, but that only works fast if there are few invalid geometries:

Then the planner is stupid, because it is actually checking stuff that
is already indexed. It should rewrite the query to use the index, that
is the index for.

If PostgreSQL pretends that it accepts manual indices then it should use
them.


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

iEYEAREKAAYFAkxz9mYACgkQYH1+F2Rqwn3uaQCaA5DT6IgmtmCmTs6Z79rWO7M7
i7QAnRl0rpe0nyk/nZEi1AvsEQbcFSnb
=VsHA
-----END PGP SIGNATURE-----



More information about the dev mailing list