[Tile-serving] [osm2pgsql] Clustering strategies (#208)

[Paul Norman]

`CREATE TABLE ... ORDER BY ...` took 1933s while `CREATE INDEX ... ST_GeoHash...; CLUSTER ...; DROP INDEX ...;` took 47734s, mainly in the CLUSTER.

Unfortunately, I just realized that I did this with default work_mem and maintenance_work_mem, which make the results bad.

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