[Tile-serving] [osm2pgsql] planet_osm_ways coming out bloated (#111)

[Paul Norman]

I'm wondering, do we need to store pending in the database at all? Isn't `pending=true` only found when importing or within an update transaction?

If so, could we cache pending status in memory? There's only ~250 million ways, which at 1 bit each would take about 30 megs of RAM to cache. We'd save a disk write because we'd no longer write with `pending=true` then update to `pending=false`. We'd lose the smaller partial index, but we're not currently getting much benefit from that thanks to #105, and even with that fixed we could end up ahead on IO anyways.

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