[Tile-serving] [osm2pgsql-dev/osm2pgsql] Up speed flex output with --create (Discussion #2341)

Arhat109 notifications at github.com
Thu Jun 5 08:10:16 UTC 2025


Way.. all planet.osm.pbf started writing way'a table! Nodes was writed 10 hours. Now, I see this:
```
102469 | 07:24:38.128423 | user_admin | COPY "public"."planet_osm_ways" FROM STDIN
 104002 | 00:00:00.000784 | user_admin | SELECT id, lon, lat FROM "public"."planet_osm_nodes" WHERE id = ANY($1::int8[])
 104025 | 00:01:00.250268 | user_admin | COPY "public"."ways" ("id","imported_id","version","user_id","tstamp","changeset_id","tags","linestring","nodes_hash","highway","building") FROM STDIN
```
It means that SELECT selecting only 1 node and COPY are storing only one way at once too.. brainly. :(

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

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


More information about the Tile-serving mailing list