[Tile-serving] [osm2pgsql-dev/osm2pgsql] Daylight Ingest and Slow Deletions (Discussion #2088)

[pyoung-sc]

Using the parameters recommended in the manual trimmed off about 12 hours:
```
Reading input files done in 109127s (30h 18m 47s).
2023-10-26 06:23:01    Processed 12427938028 nodes in 1899s (31m 39s) - 6544k/s
2023-10-26 06:23:01    Processed 1779505585 ways in 23308s (6h 28m 28s) - 76k/s
2023-10-26 06:23:01    Processed 10383411 relations in 83920s (23h 18m 40s) - 124/s
2023-10-26 06:23:01  Reprocess marked ways (stage 2)...
2023-10-26 06:23:04  Creating id index on table 'planet_osm_line'...
2023-10-26 07:41:11  Creating id index on table 'planet_osm_polygon'...
2023-10-26 07:59:33  Creating id index on table 'planet_osm_roads'...
2023-10-26 09:13:59  Creating id indexes took 10258s (2h 50m 58s)
2023-10-26 09:14:00  There are 3064634 ways to reprocess...
2023-10-26 11:22:59  Clustering table 'planet_osm_point' by geometry...
2023-10-26 11:23:02  Done postprocessing on table 'planet_osm_nodes' in 0s
2023-10-26 11:23:02  Building index on table 'planet_osm_ways'
2023-10-26 11:23:02  Building index on table 'planet_osm_rels'
2023-10-26 11:23:04  Clustering table 'planet_osm_line' by geometry...
2023-10-26 11:23:04  Clustering table 'planet_osm_roads' by geometry...
2023-10-26 11:23:04  Clustering table 'planet_osm_polygon' by geometry...
2023-10-26 11:40:25  Creating index on table 'planet_osm_point' ("way")...
2023-10-26 11:50:59  Creating id index on table 'planet_osm_point'...
2023-10-26 11:52:39  Analyzing table 'planet_osm_point'...
2023-10-26 15:19:06  Creating index on table 'planet_osm_polygon' ("way")...
2023-10-26 16:59:31  Creating id index on table 'planet_osm_polygon'...
2023-10-26 17:16:44  Analyzing table 'planet_osm_polygon'...
2023-10-26 21:00:37  Done postprocessing on table 'planet_osm_ways' in 34654s (9h 37m 34s)
2023-10-26 21:00:37  Done postprocessing on table 'planet_osm_rels' in 262s (4m 22s)
2023-10-26 21:00:37  All postprocessing on table 'planet_osm_point' done in 1784s (29m 44s).
2023-10-27 11:01:31  Creating index on table 'planet_osm_roads' ("way")...
2023-10-27 11:40:20  Creating index on table 'planet_osm_line' ("way")...
2023-10-27 17:53:36  Creating id index on table 'planet_osm_roads'...
2023-10-27 18:49:15  Analyzing table 'planet_osm_roads'...
2023-10-27 18:58:35  Creating id index on table 'planet_osm_line'...
2023-10-27 19:55:28  Analyzing table 'planet_osm_line'...
2023-10-27 19:55:30  All postprocessing on table 'planet_osm_line' done in 117155s (32h 32m 35s).
2023-10-27 19:55:30  All postprocessing on table 'planet_osm_polygon' done in 21231s (5h 53m 51s).
2023-10-27 19:55:30  All postprocessing on table 'planet_osm_roads' done in 113181s (31h 26m 21s).
2023-10-27 19:55:30  Storing properties to table '"public"."osm2pgsql_properties"'.
2023-10-27 19:55:30  osm2pgsql took 244276s (67h 51m 16s) overall.
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2088#discussioncomment-7408061
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2088/comments/7408061 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231027/7b7d7bf8/attachment.htm>