[Tile-serving] [osm2pgsql] Not creating indexes? (#326)
Venex
notifications at github.com
Wed Apr 8 06:10:30 UTC 2015
I do not properly understand your first question.
Committing transactions is the last action executed and the application will exit.
See:
<pre>osm2pgsql SVN version 0.87.3-dev (64bit id space)
Using built-in tag processing pipeline
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=2000MB, maxblocks=256000*8192, allocation method=11
Mid: pgsql, scale=100 cache=2000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Reading in file: /home/tileuser/Documents/europe-latest.osm.pbf
Processing: Node(10k 10.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(20k 20.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
... etc etc...
Processing: Node(1441488k 182.3k/s) Way(176918k 7.39k/s) Relation(2307960 114.90/s)
Processing: Node(1441488k 182.3k/s) Way(176918k 7.39k/s) Relation(2307970 114.90/s) parse time: 51945s
Node stats: total(1441488525), max(3416627506) in 7909s
Way stats: total(176918078), max(334598994) in 23950s
Relation stats: total(2307971), max(4726594) in 20086s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads</pre>
Assumingly creation of indexes is missing.
I ran
<pre>sudo -u postgres osm2pgsql --slim -d gis -C 2000 --number-processes 4 /home/tileuser/Documents/europe-latest.osm.pbf</pre>
I did not check out a version before building, just grabbed latest, which seems to be 0.87.3-dev
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/326#issuecomment-90816881
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150407/66f28992/attachment.html>
More information about the Tile-serving
mailing list