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

[Paul Norman]

> default indexes in osm2pgsql would be nice to have

osm2pgsql does have default indexes. Yes, you can gain more performance by stylesheet dependent custom partial indexes, but those will probably be at most a 40% performance gain, and require customizing to your stylesheet and application. If you interrupt an import before it's complete, then obviously not all the steps are done, and the last step is index creation and ``ANALYZE;``

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