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

[pyoung-sc]

@pnorman Good news, with 1.9.2 it got past where 1.5.1 was stuck!

```
2023-10-05 03:31:38  Reading input files done in 167714s (46h 35m 14s).
2023-10-05 03:31:38    Processed 12349015866 nodes in 2817s (46m 57s) - 4384k/s
2023-10-05 03:31:38    Processed 1770379046 ways in 37281s (10h 21m 21s) - 47k/s
2023-10-05 03:31:38    Processed 10285732 relations in 127616s (35h 26m 56s) - 81/s
2023-10-05 03:31:39  Reprocess marked ways (stage 2)...
2023-10-05 03:31:44  Creating id index on table 'planet_osm_line'...
2023-10-05 04:52:38  Creating id index on table 'planet_osm_polygon'...
2023-10-05 05:12:10  Creating id index on table 'planet_osm_roads'...
2023-10-05 06:27:12  Creating id indexes took 10532s (2h 55m 32s)
2023-10-05 06:27:12  There are 3011391 ways to reprocess...
2023-10-05 09:41:30  Done postprocessing on table 'planet_osm_nodes' in 0s
2023-10-05 09:41:30  Building index on table 'planet_osm_rels'
2023-10-05 09:41:30  Building index on table 'planet_osm_ways'
2023-10-05 09:41:32  Clustering table 'planet_osm_point' by geometry...
2023-10-05 09:41:35  Clustering table 'planet_osm_roads' by geometry...
2023-10-05 09:41:35  Clustering table 'planet_osm_polygon' by geometry...
2023-10-05 09:41:35  Clustering table 'planet_osm_line' by geometry...
2023-10-05 10:16:40  Creating index on table 'planet_osm_point' ("way")...
2023-10-05 10:28:23  Creating id index on table 'planet_osm_point'...
2023-10-05 10:29:50  Analyzing table 'planet_osm_point'...
```

The bad news is there was a `Segmentation fault      (core dumped)...` after that last line.

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

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