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

[Paul Norman]

Not sure what the issue being reported here is.

If possible, you want to use partial geometry indexes, not the indexes suggested in the link.

e.g. 
``CREATE INDEX ON planet_osm_polygon USING gist (way) WHERE building IS NULL.`` or ``CREATE INDEX ON planet_osm_roads USING gist (way) WHERE route = 'ferry'``;

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