[Tile-serving] [osm2pgsql] Not creating indexes? (#326)

Venex notifications at github.com
Wed Apr 8 05:44:38 UTC 2015


Dear pnorman, this is the output of a new execution:

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

Thats it.

Seems to be missing some statements I've seen before:

Sorting data and creating indexes for planet_osm_polygon
Sorting data and creating indexes for planet_osm_roads
Sorting data and creating indexes for planet_osm_line
Sorting data and creating indexes for planet_osm_point
Building index on table: planet_osm_rels
Building index on table: planet_osm_ways

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


More information about the Tile-serving mailing list