leijurv left a comment (osm2pgsql-dev/osm2pgsql#2482)
Here is an updated table. I restarted postgres between each run, and I used
drop_caches as well. It is several times slower which is probably what you
expected?
| expired tile | region | walk | collect | delete | insert | total |
|---------------|--------|------|---------|--------|--------|--------|
| z13 | 74 | 267 | 42 | 206 | 53 | 642 ms |
| z14 | 66 | 176 | 20 | 95 | 23 | 382 ms |
| z15 | 85 | 96 | 9 | 53 | 16 | 259 ms |
| z16 | 73 | 76 | 6 | 41 | 16 | 212 ms |
| z17 | 65 | 58 | 6 | 29 | 6 | 164 ms |
| z18 | 69 | 55 | 6 | 28 | 6 | 165 ms |
| z19 | 67 | 54 | 7 | 28 | 5 | 161 ms |
| z20 | 71 | 60 | 9 | 27 | 8 | 175 ms |
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/pull/2482#issuecomment-4605092533
You are receiving this because you are subscribed to this thread.
Message ID: <osm2pgsql-dev/osm2pgsql/pull/2482/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving