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

[Paul Norman]

Post-processing taking that long indicates extremely slow ordering and index builds, likely from not having enough work_mem or maintenance_work_mem. This doesn't depend on osm2pgsql performance, as it's just SQL statements.

Slow relations is not surprising if there's osm2pgsql to DB latency, as most of the time is spent geom building and getting the information to build geoms.

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

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