[Tile-serving] [openstreetmap/osm2pgsql] Suggestion: middle-pgsql stats for hit/miss (#1323)

[tiedotguy]

As a practical difference, with some hacked up code, I came up with the following when importing New South Wales, with various cache sizes:

- 512MB: 105 seconds, 99.97% cache, 238 db hits, 1492504 avoids, 99.98%
- 256MB: 131 seconds, 95.24% cache, 96358 db hits, 1396384 avoids, 93.54%
- 128MB: 327 seconds, 52.91% cache, 896566 db hits, 596176 avoids, 60.06%
- no cache: 399 seconds, 0% cache, 1492742 db hits, 0 avoids, 0%

(99.97% is as high as it can go, because there are referenced nodes which don't exist in the extract)

-- 
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/1323#issuecomment-727290940
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20201114/510fa259/attachment.htm>