[OSM-dev] Patch to speed up planet dumps

Martijn van Oosterhout kleptog at gmail.com
Mon Sep 3 08:11:58 BST 2007


I looked at the planet dump code and its use of LIMIT/OFFSET is, well,
silly as well as terribly slow towards the end of the table. Attached
is a patch that uses the index on "id" to jump directly to the right
point in the table to continue from. Theoretically it should speed up
the dump, especially as the table gets larger.

Could somebody will ruby skills check over it to see if the syntax is ok?

Have a nice day.
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: planet-speedup.patch
Type: text/x-diff
Size: 3456 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070903/89908390/attachment.patch>


More information about the dev mailing list