[Tile-serving] [osm2pgsql] Good cheaper indexing (#171)

[Paul Norman]

> Stupid question, do you know if mapnik uses geometry indexes ? I couldn't find it in the source.

No, indexes are used by postgres, not mapnik. No programs connecting to a database use indexes.

The queries you normally get out of mapnik will make use of an index on geometry if available. It is of course possible to write a query which can't use a geometry index, but you have to be doing something more advanced, generally with postgis geometry operations, and if doing so you need to craft the query so that it can use a geometry index.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/171#issuecomment-49569311
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140720/2974b2da/attachment.html>