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

[apmon]

Yes, the index is needed during diff imports. At the end of each run of osm2pgsql there shouldn't be any pending ways left though. So 8kb sounds about right at then end of a osm2pgsql run.

The index is also used during the "going over pending ways" stage of the initial import, for which there is a very large number of pending ways. But given that, it might be better to only create that index after the end of pending ways and rely on a seq scan for the pending ways query during initial import.

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