[Tile-serving] [osm2pgsql] Don't analyze before copying tables (#303)

Paul Norman notifications at github.com
Sun Feb 22 10:34:44 UTC 2015


osm2pgsql was running analyze twice on tables, once before indexes
and copying tables, once after. This first analyze wasn't needed.
The copying to new tables always runs a sequential scan, and
the index creation doesn't depend on planner statistics and also
forces a sequential scan of the table.

An analyze is run later on before osm2pgsql exits.
You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/osm2pgsql/pull/303

-- Commit Summary --

  * Don't analyze before copying tables

-- File Changes --

    M table.cpp (2)

-- Patch Links --

https://github.com/openstreetmap/osm2pgsql/pull/303.patch
https://github.com/openstreetmap/osm2pgsql/pull/303.diff

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/303
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150222/bce4e448/attachment.html>


More information about the Tile-serving mailing list