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

[tiedotguy]

If any node in a way is not in the cache, then the cost of the `local_nodes_get_list` becomes the cost of a database access. 

The difference between a db access for 1 node vs 10 nodes is low, but 0 nodes vs 1 nodes is large.  Effectively this means a 90% hit rate is a 0% hit rate, making the stats less meaningful.

As an alternative way of looking at this, I suggest having `middle_pgsql_t` keep track of "entire lookup satisfied by cache" vs "entire lookup not satisfied by cache", as I believe it's more meaningful.  This wouldn't change anything with the current stats.

Thoughts?

-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20201114/66e8dc4b/attachment.htm>