[Tile-serving] [osm2pgsql] switch to turn off clustering (#525)

[TobWen]

Right now, osm2pgsql creates prefix_* on import Then the data gets copied to a table called prefix_*_tmp by a selection ordered by GeoHash Afterwards, the old prefix_* gets removed and prefix_*_tmp is renamed to prefix_* Before the old table gets removed, the import takes twice the amount on the discs

Could you please add a switch to turn off clustering of databases (using GeoHash)? Sure, there's a benefit in sorting data on the drive, but on smaller SSDs, there will be problems importing big datasets Since there's an index on the geometry and since updates don't get sorted at all, turning off "sort in index" might be a solution for users with small SSDs only

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