[Tile-serving] [openstreetmap/osm2pgsql] loading to the database hangs both in Ubuntu 22.04 (wsl2) and windows 11 (Issue #1956)

[Vitaly Zabavin]

 d:\osm\osm2pgsql>osm2pgsql -d iadmin -H localhost -P 5432 -U postgres --proj 4326 -W -C32000 -p kz -S d:\osm\osm2pgsql\default.style  d:\osm\kz.pbf --log-level=debug
2023-05-04 10:18:40  osm2pgsql version 1.8.1
Password:
2023-05-04 10:18:44  [0] Database version: 15.2 (Ubuntu 15.2-1.pgdg22.04+1)
2023-05-04 10:18:44  [0] PostGIS version: 3.3
2023-05-04 10:18:44  [0] Reading file: d:\osm\kz.pbf
2023-05-04 10:18:44  [0] Started pool with 4 threads.
2023-05-04 10:18:44  [0] Using projection SRS 4326 (Latlong)
2023-05-04 10:18:44  [0] Using built-in tag transformations
2023-05-04 10:18:44  [0] Middle 'ram' options:
2023-05-04 10:18:44  [0]   locations: true
2023-05-04 10:18:44  [0]   way_nodes: true
2023-05-04 10:18:44  [0]   nodes: false
2023-05-04 10:18:44  [0]   untagged_nodes: false
2023-05-04 10:18:44  [0]   ways: false
2023-05-04 10:18:44  [0]   relations: false
2023-05-04 10:18:44  [0] Setting up table 'kz_point'
2023-05-04 10:18:44  [0] Setting up table 'kz_line'
2023-05-04 10:18:44  [0] Setting up table 'kz_polygon'
2023-05-04 10:18:44  [0] Setting up table 'kz_roads'
2023-05-04 10:19:08  [0] Reading input files done in 24s.
2023-05-04 10:19:08  [0]   Processed 24390731 nodes in 2s - 12195k/s
2023-05-04 10:19:08  [0]   Processed 2939690 ways in 18s - 163k/s
2023-05-04 10:19:08  [0]   Processed 12711 relations in 4s - 3k/s
2023-05-04 10:19:08  [0] Middle 'ram': Node locations: size=24390731 bytes=200M
2023-05-04 10:19:08  [0] Middle 'ram': Way nodes data: size=50660072 capacity=67474872 bytes=64M
2023-05-04 10:19:08  [0] Middle 'ram': Way nodes index: size=2939690 capacity=3145728 bytes=24M
2023-05-04 10:19:08  [0] Middle 'ram': Object data: size=0 capacity=1048576 bytes=1M
2023-05-04 10:19:08  [0] Middle 'ram': Object indexes: size=0 capacity=0 bytes=0M
2023-05-04 10:19:08  [0] Middle 'ram': Memory used overall: 290MBytes
2023-05-04 10:19:08  [2] Starting task...
2023-05-04 10:19:08  [3] Starting task...
2023-05-04 10:19:08  [4] Starting task...
2023-05-04 10:19:08  [1] Starting task...
2023-05-04 10:19:08  [2] Clustering table 'kz_line' by geometry...
2023-05-04 10:19:08  [3] Clustering table 'kz_polygon' by geometry...
2023-05-04 10:19:08  [4] Clustering table 'kz_roads' by geometry...
2023-05-04 10:19:08  [1] Clustering table 'kz_point' by geometry...
2023-05-04 10:19:08  [2] Using native order for clustering table 'kz_line'
2023-05-04 10:19:08  [3] Using native order for clustering table 'kz_polygon'
2023-05-04 10:19:08  [4] Using native order for clustering table 'kz_roads'
2023-05-04 10:19:08  [1] Using native order for clustering table 'kz_point'


now 12:04 
task manager load 0%
cancel task 
 





-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1956#issuecomment-1534354663
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1956/1534354663 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230504/a2f22d4b/attachment-0001.htm>