[Tile-serving] [osm2pgsql] spatial indexes haven't been built (#526)

TobWen notifications at github.com
Fri Jan 8 15:38:33 UTC 2016


I'm usin osm2pgsql (commit ccd4ebe9a6b1a051031bdbd3f83c7558df0d5ff8) After some hours of importing, no spatial indexes (GIST) have been built

This is my command line:
```
osm2pgsql --create --tablespace-main-data ssd01 --tablespace-slim-data ssd01 --flat-nodes /mnt/ssd02/flatnodes --cache-strategy optimized --cache 14000 --database gis --hstore-all --hstore-add-index --latlong --number-processes 4 --slim --reproject-area --style /opt/osm/import_2016-01-07style --extra-attributes --verbose -U postgres europe_2016-01-07o5m
```

That's a log from osm2pgsql (I've added timestamps):
```
1452242163	2016-01-08	08:36:03	Completed planet_osm_line
1452242163	2016-01-08	08:36:03	Completed planet_osm_point
1452242163	2016-01-08	08:36:03	Completed planet_osm_polygon
1452242163	2016-01-08	08:36:03	Completed planet_osm_roads
1452242163	2016-01-08	08:36:03	Stopping table: planet_osm_nodes
1452242163	2016-01-08	08:36:03	Stopped table: planet_osm_nodes in 0s
1452242163	2016-01-08	08:36:03	Stopping table: planet_osm_ways
1452242163	2016-01-08	08:36:03	Building index on table: planet_osm_ways
1452247589	2016-01-08	10:06:29	Stopped table: planet_osm_ways in 5426s
1452247589	2016-01-08	10:06:29	Stopping table: planet_osm_rels
1452247589	2016-01-08	10:06:29	Building index on table: planet_osm_rels
1452247658	2016-01-08	10:07:38	Stopped table: planet_osm_rels in 69s
1452247659	2016-01-08	10:07:39	Maximum node in persistent node cache: 3909091327
1452247660	2016-01-08	10:07:40	Maximum node in persistent node cache: 3909091327
1452247661	2016-01-08	10:07:41	Maximum node in persistent node cache: 3909091327
1452247662	2016-01-08	10:07:42	Maximum node in persistent node cache: 3909091327
```

The import has been completed without other problems, data seems to be complete All other indexes (primary keys and btree for slim tables) have been set Also, there are no errors in postgresql's log file

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


More information about the Tile-serving mailing list