[Tile-serving] [openstreetmap/osm2pgsql] Slow --append node processing with osm2pgsql 1.8.1 (7-8* slower than older setup) (Discussion #1971)

[Ryan Lambert]

Hi @wgds60 - My recent experience using `--append` showed it was very slow with osm2pgsql 1.7.2, but I didn't have any historic expectations to reference against.  The last part of [this comment](https://github.com/rustprooflabs/pgosm-flex/issues/275#issuecomment-1340362190) explains:

> "Loading additional files with osm2pgsql --append is pretty slow [it seems](https://help.openstreetmap.org/questions/73240/osm2pgsql-append-is-extremely-slow). I loaded an initial D.C. sized region (18 MB) took 40 seconds, with nodes processing at 450k/s. The New Hampshire (52 MB) addition via osm2pgsql --append took 23.5 minutes, only 5 k/s processing speed on nodes."



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

Message ID: <openstreetmap/osm2pgsql/repo-discussions/1971/comments/6091183 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230605/f157329e/attachment.htm>