[Tile-serving] [osm2pgsql] planet_osm_ways_idx partial index comes out amazingly bloated (#105)

Paul Norman notifications at github.com
Thu Dec 5 09:32:17 UTC 2013


`"planet_osm_rels_idx"` is the `btree (id) WHERE pending` index.

On a fresh import this comes out as 3634 MB. A reindex brings this down to 8 kB. This is obviously absurdly bloated. We should either reindex at the end, or defer index creation until after pending ways if possible.

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


More information about the Tile-serving mailing list