[Tile-serving] [openstreetmap/osm2pgsql] Something wrong with indexes during import (#1436)

[Andrey Novikov]

**Re boundaries**

Way can be related to multiple boundaries - it can be a boundary of a country, of an adjacent country, of a state and a district. This way can also be a river or a road. My goal is to get the most significant boundary for that way (because boundaries are semi-transparent on my map and it will be a mess as it will be drawn several times if I will just convert relations to multilinestrings). I also pass that way to lines if it has any other significant tags. May be I didn't understand flex stages right but I do not know how to achieve that without recreating the lines.

**Re DB query**

As I said there is a DELETE process using 100% CPU during that long pause. And there are no any other DELETE queries in the list. And, yes, it is 'active', I've made `SELECT * FROM pg_stat_activity` first. I will try `auto_explain` later when I will further play with lua script. I am short of disk space and each full import requires deleting supplementary data from database that I have later to recreate or reimport as there is currently no way to disable geom clustering which takes lot of temporary space.

** Re cache **

Yes, I have 64GB of memory and do not experience any shortage. I've thought that cache is used not only for nodes.

-- 
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-808781556
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210327/4e0064dc/attachment.htm>