Created
October 31, 2013 21:34
-
-
Save springmeyer/7257601 to your computer and use it in GitHub Desktop.
Osm2pgsql regression-test.py output at the v0.84.0 tag
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ python tests/regression-test.py | |
| Setting up test database | |
| For the test, we need to create a tablespace. This needs root privilidges | |
| sudo: /bin/chown: command not found | |
| ....osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point" does not exist, skipping | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line" does not exist, skipping | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon" does not exist, skipping | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads" does not exist, skipping | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=3 | |
| Mid: Ram, scale=100 | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 0s | |
| Node stats: total(65733), max(2403384707) in 0s | |
| Way stats: total(7121), max(232012458) in 0s | |
| Relation stats: total(113), max(3090789) in 0s | |
| Committing transaction for planet_osm_point | |
| Committing transaction for planet_osm_line | |
| Committing transaction for planet_osm_polygon | |
| Committing transaction for planet_osm_roads | |
| Writing way (7k) | |
| Committing transaction for planet_osm_point | |
| Committing transaction for planet_osm_line | |
| Committing transaction for planet_osm_polygon | |
| Committing transaction for planet_osm_roads | |
| Writing relation (113) | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Sorting data and creating indexes for planet_osm_polygon | |
| Analyzing planet_osm_roads finished | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 1s overall | |
| **************************************** | |
| Running initial import for basic case | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| NOTICE: table "planet_osm_nodes" does not exist, skipping | |
| Setting up table: planet_osm_ways | |
| NOTICE: table "planet_osm_ways" does not exist, skipping | |
| Setting up table: planet_osm_rels | |
| NOTICE: table "planet_osm_rels" does not exist, skipping | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Analyzing planet_osm_roads finished | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating indexes on planet_osm_roads finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 1s | |
| Completed planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 1s | |
| Completed planet_osm_line | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for slim --drop case | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 4326 (Latlong) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=3 | |
| Mid: Ram, scale=10000000 | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 0s | |
| Node stats: total(65733), max(2403384707) in 0s | |
| Way stats: total(7121), max(232012458) in 0s | |
| Relation stats: total(113), max(3090789) in 0s | |
| Committing transaction for planet_osm_point | |
| Committing transaction for planet_osm_line | |
| Committing transaction for planet_osm_polygon | |
| Committing transaction for planet_osm_roads | |
| Writing way (7k) | |
| Committing transaction for planet_osm_point | |
| Committing transaction for planet_osm_line | |
| Committing transaction for planet_osm_polygon | |
| Committing transaction for planet_osm_roads | |
| Writing relation (113) | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_polygon | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Analyzing planet_osm_polygon finished | |
| Creating indexes on planet_osm_point finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 1s | |
| Completed planet_osm_line | |
| Osm2pgsql took 2s overall | |
| **************************************** | |
| Running initial import for lat lon projection | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using lua based tag processing pipeline with script style.lua | |
| Error: Could not init lua tag transform, as lua support was not compiled into this version | |
| Error: Failed to initialise tag processing. | |
| Error occurred, cleaning up | |
| E..osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point" does not exist, skipping | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line" does not exist, skipping | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon" does not exist, skipping | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads" does not exist, skipping | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| NOTICE: table "planet_osm_nodes" does not exist, skipping | |
| Setting up table: planet_osm_ways | |
| NOTICE: table "planet_osm_ways" does not exist, skipping | |
| Setting up table: planet_osm_rels | |
| NOTICE: table "planet_osm_rels" does not exist, skipping | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed 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_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| Analyzing planet_osm_line finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Stopped table: planet_osm_ways in 1s | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_line created in 1s | |
| Completed planet_osm_line | |
| All indexes on planet_osm_polygon created in 1s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for basic case | |
| ********************************* | |
| Running diff-import for basic case | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 8 helper-processes | |
| Helper process 6 out of 8 initialised | |
| Process 6 finished processing 520 ways in 2 sec | |
| Helper process 0 out of 8 initialised | |
| Helper process 1 out of 8 initialised | |
| Helper process 2 out of 8 initialised | |
| Helper process 4 out of 8 initialised | |
| Helper process 7 out of 8 initialised | |
| Helper process 3 out of 8 initialised | |
| Helper process 5 out of 8 initialised | |
| Process 0 finished processing 521 ways in 3 sec | |
| Process 2 finished processing 520 ways in 4 sec | |
| Process 7 finished processing 520 ways in 4 sec | |
| Process 3 finished processing 520 ways in 4 sec | |
| Process 5 finished processing 520 ways in 4 sec | |
| Process 4 finished processing 520 ways in 4 sec | |
| Process 1 finished processing 521 ways in 4 sec | |
| All child processes exited | |
| 4162 Pending ways took 4s at a rate of 1040.50/s | |
| 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 8 helper-processes | |
| Process 5 finished processing 0 relations in 1 sec | |
| Process 0 finished processing 0 relations in 2 sec | |
| Process 3 finished processing 0 relations in 2 sec | |
| Process 2 finished processing 0 relations in 2 sec | |
| Process 1 finished processing 0 relations in 2 sec | |
| Process 4 finished processing 0 relations in 2 sec | |
| Process 6 finished processing 0 relations in 2 sec | |
| Process 7 finished processing 0 relations in 2 sec | |
| All child processes exited | |
| 0 Pending relations took 2s at a rate of 0.00/s | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating geometry index on planet_osm_polygon | |
| Creating osm_id index on planet_osm_line | |
| Stopped table: planet_osm_ways in 0s | |
| Creating indexes on planet_osm_line finished | |
| Creating osm_id index on planet_osm_polygon | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 7s overall | |
| **************************************** | |
| Running initial import for Parallel processing | |
| ********************************* | |
| Running diff-import for Parallel processing | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 2s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 8 helper-processes | |
| Helper process 4 out of 8 initialised | |
| Helper process 7 out of 8 initialised | |
| Process 7 finished processing 83 ways in 1 sec | |
| Process 4 finished processing 83 ways in 1 sec | |
| Helper process 0 out of 8 initialised | |
| Helper process 3 out of 8 initialised | |
| Helper process 2 out of 8 initialised | |
| Helper process 6 out of 8 initialised | |
| Helper process 5 out of 8 initialised | |
| Helper process 1 out of 8 initialised | |
| Process 0 finished processing 84 ways in 2 sec | |
| Process 6 finished processing 83 ways in 2 sec | |
| Process 2 finished processing 84 ways in 2 sec | |
| Process 5 finished processing 83 ways in 2 sec | |
| Process 3 finished processing 83 ways in 2 sec | |
| Process 1 finished processing 84 ways in 2 sec | |
| All child processes exited | |
| 667 Pending ways took 2s at a rate of 333.50/s | |
| 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... | |
| 4 relations are pending | |
| Using 8 helper-processes | |
| Process 5 finished processing 0 relations in 1 sec | |
| Process 1 finished processing 1 relations in 1 sec | |
| Process 0 finished processing 1 relations in 2 sec | |
| Process 6 finished processing 0 relations in 2 sec | |
| Process 4 finished processing 0 relations in 2 sec | |
| Process 7 finished processing 0 relations in 2 sec | |
| Process 3 finished processing 1 relations in 2 sec | |
| Process 2 finished processing 1 relations in 2 sec | |
| All child processes exited | |
| 4 Pending relations took 2s at a rate of 2.00/s | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.03% | |
| Completed planet_osm_polygon | |
| Completed planet_osm_roads | |
| Completed planet_osm_line | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 6s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| Allocating memory for dense node cache | |
| Allocating dense node cache in one big chunk | |
| Node-cache: cache=1MB, maxblocks=128*8192, allocation method=10 | |
| Mid: pgsql, scale=100 cache=1 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 2s | |
| Node stats: total(65733), max(2403384707) in 1s | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 8 helper-processes | |
| Helper process 6 out of 8 initialised | |
| Helper process 2 out of 8 initialised | |
| Process 2 finished processing 520 ways in 1 sec | |
| Process 6 finished processing 520 ways in 1 sec | |
| Helper process 0 out of 8 initialised | |
| Helper process 1 out of 8 initialised | |
| Helper process 3 out of 8 initialised | |
| Helper process 7 out of 8 initialised | |
| Helper process 5 out of 8 initialised | |
| Helper process 4 out of 8 initialised | |
| Process 0 finished processing 521 ways in 2 sec | |
| Process 5 finished processing 520 ways in 2 sec | |
| Process 4 finished processing 520 ways in 2 sec | |
| Process 7 finished processing 520 ways in 2 sec | |
| Process 3 finished processing 520 ways in 2 sec | |
| Process 1 finished processing 521 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 8 helper-processes | |
| Process 2 finished processing 0 relations in 2 sec | |
| Process 0 finished processing 0 relations in 2 sec | |
| Process 3 finished processing 0 relations in 3 sec | |
| Process 6 finished processing 0 relations in 3 sec | |
| Process 7 finished processing 0 relations in 3 sec | |
| Process 5 finished processing 0 relations in 3 sec | |
| Process 4 finished processing 0 relations in 3 sec | |
| Process 1 finished processing 0 relations in 3 sec | |
| All child processes exited | |
| 0 Pending relations took 3s at a rate of 0.00/s | |
| node cache: stored: 36338(55.28%), storage efficiency: 27.72% (dense blocks: 128, sparse nodes: 0), hit rate: 47.63% | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_polygon | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_polygon finished | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 0s | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 7s overall | |
| **************************************** | |
| Running initial import for Parallel processing with non 100% node-cache | |
| ********************************* | |
| Running diff-import for Parallel processing with non 100% node-cache | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| Allocating memory for dense node cache | |
| Allocating dense node cache in one big chunk | |
| Node-cache: cache=1MB, maxblocks=128*8192, allocation method=10 | |
| Mid: pgsql, scale=100 cache=1 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 2s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 0s | |
| Relation stats: total(19), max(3119940) 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 | |
| Going over pending ways... | |
| 667 ways are pending | |
| Using 8 helper-processes | |
| Helper process 7 out of 8 initialised | |
| Helper process 3 out of 8 initialised | |
| Process 7 finished processing 83 ways in 1 sec | |
| Process 3 finished processing 83 ways in 1 sec | |
| Helper process 0 out of 8 initialised | |
| Helper process 4 out of 8 initialised | |
| Helper process 2 out of 8 initialised | |
| Helper process 5 out of 8 initialised | |
| Helper process 1 out of 8 initialised | |
| Helper process 6 out of 8 initialised | |
| Process 0 finished processing 84 ways in 2 sec | |
| Process 6 finished processing 83 ways in 2 sec | |
| Process 4 finished processing 83 ways in 2 sec | |
| Process 1 finished processing 84 ways in 2 sec | |
| Process 2 finished processing 84 ways in 2 sec | |
| Process 5 finished processing 83 ways in 2 sec | |
| All child processes exited | |
| 667 Pending ways took 2s at a rate of 333.50/s | |
| 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... | |
| 4 relations are pending | |
| Using 8 helper-processes | |
| Process 5 finished processing 0 relations in 1 sec | |
| Process 0 finished processing 1 relations in 2 sec | |
| Process 4 finished processing 0 relations in 2 sec | |
| Process 7 finished processing 0 relations in 2 sec | |
| Process 6 finished processing 0 relations in 2 sec | |
| Process 3 finished processing 1 relations in 2 sec | |
| Process 2 finished processing 1 relations in 2 sec | |
| Process 1 finished processing 1 relations in 2 sec | |
| All child processes exited | |
| 4 Pending relations took 2s at a rate of 2.00/s | |
| node cache: stored: 854(100.00%), storage efficiency: 4.63% (dense blocks: 18, sparse nodes: 0), hit rate: 1.03% | |
| Completed planet_osm_point | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Completed planet_osm_polygon | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 6s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| WARNING: ram cache is disabled. This will likely slow down processing a lot. | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=0MB, maxblocks=0*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=0 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 2s | |
| Node stats: total(65733), max(2403384707) in 1s | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 0(0.00%), storage efficiency: nan% (dense blocks: 0, sparse nodes: 0), hit rate: 0.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 0s | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 4s overall | |
| **************************************** | |
| Running initial import for Parallel processing with disabled node-cache | |
| ********************************* | |
| Running diff-import for Parallel processing with disabled node-cache | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| WARNING: ram cache is disabled. This will likely slow down processing a lot. | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=0MB, maxblocks=0*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=0 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 2s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 0s | |
| Relation stats: total(19), max(3119940) 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 | |
| Going over pending ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 1 sec | |
| All child processes exited | |
| 4 Pending relations took 1s at a rate of 4.00/s | |
| node cache: stored: 0(0.00%), storage efficiency: nan% (dense blocks: 0, sparse nodes: 0), hit rate: 0.00% | |
| Completed planet_osm_roads | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_ways in 0s | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 3s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| 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 | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for Hstore match only | |
| ********************************* | |
| Running diff-import for Hstore match only | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Sorting data and creating indexes for planet_osm_polygon | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Stopped table: planet_osm_ways in 1s | |
| 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 | |
| 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 | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for Hstore name column | |
| ********************************* | |
| Running diff-import for Hstore name column | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_roads | |
| Completed planet_osm_line | |
| Completed planet_osm_point | |
| Completed planet_osm_polygon | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_ways in 0s | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Way stats: total(7121), max(232012458) in 0s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 0s | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for Hstore | |
| ********************************* | |
| Running diff-import for Hstore | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_point | |
| Completed planet_osm_polygon | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 3s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 0s | |
| Creating osm_id index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_polygon finished | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for Hstore all | |
| ********************************* | |
| Running diff-import for Hstore all | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.13k/s) Relation(19 19.00/s) parse time: 7s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 6s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_point | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Completed planet_osm_polygon | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 8s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 2s | |
| Node stats: total(65733), max(2403384707) in 1s | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Creating osm_id index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating osm_id index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 1s | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 1s | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Completed planet_osm_polygon | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_line created in 1s | |
| Completed planet_osm_line | |
| Osm2pgsql took 6s overall | |
| **************************************** | |
| Running initial import for Extra tags hstore match only | |
| ********************************* | |
| Running diff-import for Extra tags hstore match only | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 2s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 0s | |
| Relation stats: total(19), max(3119940) 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 | |
| Going over pending ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 1 sec | |
| All child processes exited | |
| 4 Pending relations took 1s at a rate of 4.00/s | |
| Completed planet_osm_line | |
| Completed planet_osm_point | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_polygon | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 3s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 2s | |
| Node stats: total(65733), max(2403384707) in 1s | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Stopped table: planet_osm_ways in 1s | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| 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 | |
| Osm2pgsql took 4s overall | |
| **************************************** | |
| Running initial import for Extra tags hstore all | |
| ********************************* | |
| Running diff-import for Extra tags hstore all | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 2s | |
| Node stats: total(866), max(2407303486) in 1s | |
| Way stats: total(770), max(232378481) in 0s | |
| Relation stats: total(19), max(3119940) 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 | |
| Going over pending ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| Completed planet_osm_line | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 0s | |
| Node stats: total(65733), max(2403384707) in 0s | |
| Way stats: total(7121), max(232012458) in 0s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 2 sec | |
| All child processes exited | |
| 4162 Pending ways took 2s at a rate of 2081.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Analyzing planet_osm_point finished | |
| 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 0s | |
| Completed planet_osm_roads | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Osm2pgsql took 4s overall | |
| **************************************** | |
| Running initial import for --tablespace-main-data | |
| ********************************* | |
| Running diff-import for --tablespace-main-data | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Stopped table: planet_osm_ways in 1s | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| 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 | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for --tablespace-main-index | |
| ********************************* | |
| Running diff-import for --tablespace-main-index | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| Processing: Node(65k 65.7k/s) Way(7k 7.12k/s) Relation(110 110.00/s) parse time: 2s | |
| Node stats: total(65733), max(2403384707) in 1s | |
| 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 | |
| Going over pending ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed 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_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| Analyzing planet_osm_line finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Stopped table: planet_osm_ways in 1s | |
| Creating osm_id index on planet_osm_line | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| 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 | |
| Osm2pgsql took 4s overall | |
| **************************************** | |
| Running initial import for --tablespace-slim-data | |
| ********************************* | |
| Running diff-import for --tablespace-slim-data | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_roads | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| 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 ways... | |
| 4162 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 4162 ways in 1 sec | |
| All child processes exited | |
| 4162 Pending ways took 1s at a rate of 4162.00/s | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Analyzing planet_osm_point finished | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_point finished | |
| Analyzing planet_osm_polygon finished | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Analyzing planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Stopped table: planet_osm_ways in 1s | |
| Creating osm_id index on planet_osm_line | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| 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 | |
| Osm2pgsql took 3s overall | |
| **************************************** | |
| Running initial import for --tablespace-slim-index | |
| ********************************* | |
| Running diff-import for --tablespace-slim-index | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| 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 ways... | |
| 667 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 667 ways in 1 sec | |
| All child processes exited | |
| 667 Pending ways took 1s at a rate of 667.00/s | |
| 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... | |
| 4 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 4 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 1.59% | |
| Completed planet_osm_point | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_ways in 0s | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 2s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using lua based tag processing pipeline with script style.lua | |
| Error: Could not init lua tag transform, as lua support was not compiled into this version | |
| Error: Failed to initialise tag processing. | |
| Error occurred, cleaning up | |
| E..osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point" does not exist, skipping | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line" does not exist, skipping | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon" does not exist, skipping | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads" does not exist, skipping | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 10 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 10 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| 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 | |
| Analyzing planet_osm_point finished | |
| Analyzing planet_osm_roads finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Analyzing planet_osm_polygon finished | |
| Analyzing planet_osm_line finished | |
| 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 osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_roads finished | |
| Creating indexes on planet_osm_point finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_line | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 0s overall | |
| **************************************** | |
| Running initial import for basic case | |
| ********************************* | |
| Running diff-import for basic case | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 0s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) in 0s | |
| 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 ways... | |
| 9 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 9 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 6 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 6 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 6.83% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_roads | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 0s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 10 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 10 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_line finished | |
| Analyzing planet_osm_roads finished | |
| Stopped table: planet_osm_rels in 0s | |
| Analyzing planet_osm_polygon finished | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Creating osm_id index on planet_osm_point | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating indexes on planet_osm_point finished | |
| Creating osm_id index on planet_osm_roads | |
| Creating osm_id index on planet_osm_line | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Creating indexes on planet_osm_roads finished | |
| Creating indexes on planet_osm_line finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_polygon | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 0s overall | |
| **************************************** | |
| Running initial import for multi geometry | |
| ********************************* | |
| Running diff-import for multi geometry | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 0s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) in 0s | |
| 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 ways... | |
| 9 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 9 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 6 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 6 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 6.83% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 0s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 10 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 10 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_roads finished | |
| Analyzing planet_osm_point finished | |
| Analyzing planet_osm_line finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_polygon finished | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_point finished | |
| Creating osm_id index on planet_osm_line | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Creating indexes on planet_osm_roads finished | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 0s overall | |
| **************************************** | |
| Running initial import for hstore case | |
| ********************************* | |
| Running diff-import for hstore case | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 1s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) 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 | |
| Going over pending ways... | |
| 9 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 9 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 6 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 6 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 6.83% | |
| Completed planet_osm_line | |
| Completed planet_osm_polygon | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 1s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 10 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 10 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Analyzing planet_osm_roads finished | |
| Analyzing planet_osm_line finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_polygon finished | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways 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 osm_id index on planet_osm_point | |
| Creating indexes on planet_osm_roads finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating indexes on planet_osm_point finished | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| 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 osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 0s overall | |
| **************************************** | |
| Running initial import for hstore case | |
| ********************************* | |
| Running diff-import for hstore case | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 0s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) in 0s | |
| 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 ways... | |
| 9 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 9 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 6 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 6 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 6.83% | |
| Completed planet_osm_point | |
| Completed planet_osm_polygon | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 0s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 11 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 11 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_point finished | |
| Analyzing planet_osm_roads finished | |
| Analyzing planet_osm_line finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Analyzing planet_osm_polygon finished | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| Copying planet_osm_point to cluster by geometry finished | |
| Creating geometry index on planet_osm_point | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating geometry index on planet_osm_line | |
| All indexes on planet_osm_roads created in 0s | |
| Completed planet_osm_roads | |
| Creating osm_id index on planet_osm_point | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_point finished | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Creating indexes on planet_osm_line finished | |
| Creating osm_id index on planet_osm_polygon | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 0s overall | |
| **************************************** | |
| Running initial import for Extra tags hstore match only | |
| ********************************* | |
| Running diff-import for Extra tags hstore match only | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 0s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) in 0s | |
| 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 ways... | |
| 26 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 26 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 12 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 12 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 7.14% | |
| Completed planet_osm_line | |
| Completed planet_osm_point | |
| Completed planet_osm_roads | |
| Stopping table: planet_osm_nodes | |
| Completed planet_osm_polygon | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 0s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon.osm | |
| Processing: Node(0k 0.4k/s) Way(0k 0.14k/s) Relation(40 40.00/s) parse time: 0s | |
| Node stats: total(353), max(354) in 0s | |
| Way stats: total(140), max(140) in 0s | |
| Relation stats: total(40), max(40) in 0s | |
| 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 ways... | |
| 11 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 11 ways in 0 sec | |
| All child processes exited | |
| 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 1 helper-processes | |
| Process 0 finished processing 0 relations in 0 sec | |
| All child processes exited | |
| Sorting data and creating indexes for planet_osm_point | |
| Sorting data and creating indexes for planet_osm_line | |
| Sorting data and creating indexes for planet_osm_polygon | |
| node cache: stored: 353(100.00%), storage efficiency: 34.47% (dense blocks: 1, sparse nodes: 0), hit rate: 100.00% | |
| Sorting data and creating indexes for planet_osm_roads | |
| Analyzing planet_osm_roads finished | |
| Analyzing planet_osm_line finished | |
| Analyzing planet_osm_polygon finished | |
| Analyzing planet_osm_point finished | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Copying planet_osm_roads to cluster by geometry finished | |
| Creating geometry index on planet_osm_roads | |
| Creating osm_id index on planet_osm_roads | |
| Creating indexes on planet_osm_roads finished | |
| All indexes on planet_osm_roads created in 0s | |
| Completed 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_point | |
| Copying planet_osm_polygon to cluster by geometry finished | |
| Creating geometry index on planet_osm_polygon | |
| Copying planet_osm_line to cluster by geometry finished | |
| Creating indexes on planet_osm_point finished | |
| Creating geometry index on planet_osm_line | |
| All indexes on planet_osm_point created in 0s | |
| Completed planet_osm_point | |
| Creating osm_id index on planet_osm_polygon | |
| Creating osm_id index on planet_osm_line | |
| Creating indexes on planet_osm_line finished | |
| Creating indexes on planet_osm_polygon finished | |
| All indexes on planet_osm_line created in 0s | |
| Completed planet_osm_line | |
| All indexes on planet_osm_polygon created in 0s | |
| Completed planet_osm_polygon | |
| Osm2pgsql took 1s overall | |
| **************************************** | |
| Running initial import for Extra tags hstore match only | |
| ********************************* | |
| Running diff-import for Extra tags hstore match only | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using built-in tag processing pipeline | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/test_multipolygon_diff.osc | |
| Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(10 10.00/s) parse time: 0s | |
| Node stats: total(10), max(110739) in 0s | |
| Way stats: total(14), max(110736) in 0s | |
| Relation stats: total(10), max(36) in 0s | |
| 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 ways... | |
| 26 ways are pending | |
| Using 1 helper-processes | |
| Helper process 0 out of 1 initialised | |
| Process 0 finished processing 26 ways in 0 sec | |
| All child processes exited | |
| 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... | |
| 12 relations are pending | |
| Using 1 helper-processes | |
| Process 0 finished processing 12 relations in 0 sec | |
| All child processes exited | |
| node cache: stored: 10(100.00%), storage efficiency: 0.97% (dense blocks: 1, sparse nodes: 2), hit rate: 7.14% | |
| Completed planet_osm_line | |
| Completed planet_osm_roads | |
| Completed planet_osm_point | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Completed planet_osm_polygon | |
| Stopped table: planet_osm_ways in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Osm2pgsql took 0s overall | |
| ********************************* | |
| .osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using lua based tag processing pipeline with script style.lua | |
| Error: Could not init lua tag transform, as lua support was not compiled into this version | |
| Error: Failed to initialise tag processing. | |
| Error occurred, cleaning up | |
| Eosm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| Setting up table: planet_osm_point | |
| NOTICE: table "planet_osm_point" does not exist, skipping | |
| NOTICE: table "planet_osm_point_tmp" does not exist, skipping | |
| Setting up table: planet_osm_line | |
| NOTICE: table "planet_osm_line" does not exist, skipping | |
| NOTICE: table "planet_osm_line_tmp" does not exist, skipping | |
| Setting up table: planet_osm_polygon | |
| NOTICE: table "planet_osm_polygon" does not exist, skipping | |
| NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping | |
| Setting up table: planet_osm_roads | |
| NOTICE: table "planet_osm_roads" does not exist, skipping | |
| NOTICE: table "planet_osm_roads_tmp" does not exist, skipping | |
| Using lua based tag processing pipeline with script style.lua | |
| Error: Could not init lua tag transform, as lua support was not compiled into this version | |
| Error: Failed to initialise tag processing. | |
| Error occurred, cleaning up | |
| E..osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| NOTICE: table "place" does not exist, skipping | |
| NOTICE: type "keyvalue" does not exist, skipping | |
| NOTICE: type "wordscore" does not exist, skipping | |
| NOTICE: type "stringlanguagetype" does not exist, skipping | |
| NOTICE: type "keyvaluetype" does not exist, skipping | |
| NOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist, skipping | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/liechtenstein-2013-08-03.osm.pbf | |
| 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 1s | |
| Relation stats: total(113), max(3090789) in 0s | |
| node cache: stored: 65733(100.00%), storage efficiency: 51.16% (dense blocks: 18, sparse nodes: 55028), hit rate: 100.00% | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopping table: planet_osm_rels | |
| Stopped table: planet_osm_nodes in 0s | |
| Building index on table: planet_osm_ways (fastupdate=off) | |
| Building index on table: planet_osm_rels (fastupdate=off) | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 1s overall | |
| **************************************** | |
| Running initial import in gazetteer mode for basic case | |
| ********************************* | |
| Running diff-import in gazetteer mode for basic case | |
| osm2pgsql SVN version 0.84.0 (64bit id space) | |
| Using projection SRS 900913 (Spherical Mercator) | |
| 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=100MB, maxblocks=12800*8192, allocation method=11 | |
| Mid: pgsql, scale=100 cache=100 | |
| Setting up table: planet_osm_nodes | |
| Setting up table: planet_osm_ways | |
| Setting up table: planet_osm_rels | |
| Reading in file: tests/000466354.osc.gz | |
| Processing: Node(0k 0.9k/s) Way(0k 0.77k/s) Relation(19 19.00/s) parse time: 1s | |
| Node stats: total(866), max(2407303486) in 0s | |
| Way stats: total(770), max(232378481) in 1s | |
| Relation stats: total(19), max(3119940) in 0s | |
| node cache: stored: 854(100.00%), storage efficiency: 40.78% (dense blocks: 1, sparse nodes: 535), hit rate: 0.66% | |
| Stopping table: planet_osm_rels | |
| Stopping table: planet_osm_nodes | |
| Stopping table: planet_osm_ways | |
| Stopped table: planet_osm_nodes in 0s | |
| Stopped table: planet_osm_rels in 0s | |
| Stopped table: planet_osm_ways in 0s | |
| Osm2pgsql took 1s overall | |
| ********************************* | |
| . | |
| ====================================================================== | |
| ERROR: runTest (__main__.BasicNonSlimTestCase) | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "tests/regression-test.py", line 403, in setUp | |
| self.setUpGeneric(self.parameters, full_import_file) | |
| File "tests/regression-test.py", line 371, in setUpGeneric | |
| self.assertEqual( returncode, 0, "Execution of osm2pgsql with options: " + str(parameters) + " failed") | |
| AssertionError: Execution of osm2pgsql with options: ['--tag-transform-script', 'style.lua'] failed | |
| ====================================================================== | |
| ERROR: runTest (__main__.BasicSlimTestCase) | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "tests/regression-test.py", line 421, in setUp | |
| self.setUpGeneric(self.parameters, full_import_file) | |
| File "tests/regression-test.py", line 377, in setUpGeneric | |
| self.assertEqual( returncode, 0, "Execution of osm2pgsql --slim with options: " + str(parameters) + " failed") | |
| AssertionError: Execution of osm2pgsql --slim with options: ['--tag-transform-script', 'style.lua'] failed | |
| ====================================================================== | |
| ERROR: runTest (__main__.MultipolygonSlimTestCase) | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "tests/regression-test.py", line 442, in setUp | |
| self.setUpGeneric(self.parameters, multipoly_import_file) | |
| File "tests/regression-test.py", line 377, in setUpGeneric | |
| self.assertEqual( returncode, 0, "Execution of osm2pgsql --slim with options: " + str(parameters) + " failed") | |
| AssertionError: Execution of osm2pgsql --slim with options: ['--tag-transform-script', 'style.lua'] failed | |
| ====================================================================== | |
| ERROR: runTest (__main__.MultipolygonSlimTestCase) | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "tests/regression-test.py", line 442, in setUp | |
| self.setUpGeneric(self.parameters, multipoly_import_file) | |
| File "tests/regression-test.py", line 377, in setUpGeneric | |
| self.assertEqual( returncode, 0, "Execution of osm2pgsql --slim with options: " + str(parameters) + " failed") | |
| AssertionError: Execution of osm2pgsql --slim with options: ['--tag-transform-script', 'style.lua', '-k'] failed | |
| ---------------------------------------------------------------------- | |
| Ran 38 tests in 116.047s | |
| FAILED (errors=4) | |
| Cleaning up test database |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment