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

Thu Apr 9 06:00:33 UTC 2015

Dear Paul, thank you for your help. I'd try another import using version 0.87.2 which didn't result in creating indexes either. the pg_stat_activity table remained empty.

This is my output of liechtenstein which executed everything properly, don't know why europe stopped after committing transactions

<pre>osm2pgsql SVN version 0.87.2 (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=3000MB, maxblocks=384000*8192, allocation method=11
Mid: pgsql, scale=100 cache=3000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/tileuser/src/osm2pgsql/tests/liechtenstein-2013-08-03.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)
Processing: Node(30k 30.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(40k 40.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(50k 50.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(60k 60.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(1k 1.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(2k 2.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(3k 3.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(4k 4.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(5k 5.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(6k 6.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.00k/s) Relation(0 0.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(10 10.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(20 20.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(30 30.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(40 40.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(50 50.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(60 60.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(70 70.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(80 80.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(90 90.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(100 100.00/s)
Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s)  parse time: 1s
Node stats: total(65733), max(2403384707) in 0s
Way stats: total(7121), max(232012458) in 0s
Relation stats: total(113), max(3090789) in 1s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using built-in tag processing pipeline
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using built-in tag processing pipeline
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using built-in tag processing pipeline
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using built-in tag processing pipeline

Going over pending ways...
	4162 ways are pending

Using 4 helper-processes

Finished processing 4162 ways in 0 sec

Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending relations...
	0 relations are pending

Using 4 helper-processes

Finished processing 0 relations in 0 sec

Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes in 0s
Sorting data and creating indexes for planet_osm_point
Stopping table: planet_osm_ways
Building index on table: planet_osm_ways
Sorting data and creating indexes for planet_osm_polygon
Sorting data and creating indexes for planet_osm_line
Stopping table: planet_osm_rels
Building index on table: planet_osm_rels
Sorting data and creating indexes for planet_osm_roads
Stopped table: planet_osm_rels in 0s
Copying planet_osm_roads to cluster by geometry finished
Creating geometry index on  planet_osm_roads
Copying planet_osm_point to cluster by geometry finished
Creating geometry index on  planet_osm_point
Creating osm_id index on  planet_osm_roads
Creating indexes on  planet_osm_roads finished
Creating osm_id index on  planet_osm_point
Creating indexes on  planet_osm_point finished
All indexes on  planet_osm_roads created  in 1s
Completed planet_osm_roads
All indexes on  planet_osm_point created  in 1s
Completed planet_osm_point
Copying planet_osm_line to cluster by geometry finished
Creating geometry index on  planet_osm_line
Copying planet_osm_polygon to cluster by geometry finished
Creating geometry index on  planet_osm_polygon
Creating osm_id index on  planet_osm_line
Creating indexes on  planet_osm_line finished
Creating osm_id index on  planet_osm_polygon
Creating indexes on  planet_osm_polygon finished
Stopped table: planet_osm_ways in 1s
All indexes on  planet_osm_polygon created  in 1s
Completed planet_osm_polygon
All indexes on  planet_osm_line created  in 1s
Completed planet_osm_line
node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 99.96%

Osm2pgsql took 3s overall
</pre>

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