[Tile-serving] [openstreetmap/osm2pgsql] Something wrong with indexes during import (#1436)
Andrey Novikov
notifications at github.com
Thu Mar 25 17:25:00 UTC 2021
Very strange, I can not see it here: https://github.com/openstreetmap/osm2pgsql/blob/e15cd1a619788ad168818149c17fb08a76eeb05a/src/output-flex.cpp#L1543-L1558
But why I did think it's stage 2: about 09:30 in the morning I've run `top` and saw `postgres: 11/main: andrey gis [local] DELETE` running for about 7 hours and consuming 100% CPU. I went to see what query it was exactly executing and there was something like `DELETE FROM osm_lines WHERE id IN (... lots of ids ...)`. That's why I thought it's about stage 2 line processing.
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1436#issuecomment-807137368
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210325/e99c7ebf/attachment.htm>
More information about the Tile-serving
mailing list