[Tile-serving] [openstreetmap/osm2pgsql] [EXPERIMENTAL] Reduced way node index (#1058)

[mmd]

With bucket sizes of 16, 32 and 64 I was wondering if a “bitwise shift right” ( >> 4, >>5 and >>6) might be a bit faster when processing billions of nodes.

Right now Postgres would execute an integer division operation (that’s at least my understanding after checking the Postgres sources), which is a bit more expensive.

-- 
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/pull/1058#issuecomment-636759696
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200601/839cb99a/attachment.htm>