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

[sly - sylvain letuffe]

I'm unsure if that is related of if I should open a new issue, but that might be related to the behaviour I reported in 03/2012 here : https://lists.openstreetmap.org/pipermail/dev/2012-March/024589.html

summary :
After a fresh planet import the index on the "pending" field isn't used and lead 
to a seq scan of the planet_osm_ways table, increasing noticeably the diff 
import.
Running manually the query : "select id from planet_osm_way where pending" returns 0 elements but still takes a few tenth of seconds

To solve the problem post import, I did a re-index (reindex index planet_osm_ways_idx;) and the same query now run in less than 10ms

I did a planet import with osm2pgsql version from commit Sat Oct 19 20:31:04 2013 -0600 (Increment version to 0.85.0 to development version)
and can still see this behaviour.

If osm2pgsql arguments might matter, I can provide them


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