[osmosis-dev] Improved PostGIS Load Task

Brett Henderson brett at bretth.com
Mon May 17 12:13:16 BST 2010


Hey All,

I've created a new --fast-write-pgsql task which uses the new JDBC COPY
command support to improve import speeds.  I've also introduced a new
nodeLocationStoreType option called "CompactTempFile" which only stores data
for nodes that exist in the input file instead of a flat array based file.

Using the new command with the new store type there is no slowdown compared
to the old --write-pgsql task.  For large data sets there should be fairly
significant speedups.  Unless there's major objections I'll probably remove
the --write-pgsql task soon.  Maintaining two equivalent implementations
isn't something I'm keen to do.

I'm also tempted to delete the --write-pgsql-dump task which should also be
obsoleted by this new task.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/osmosis-dev/attachments/20100517/aa2e1f3b/attachment.html>


More information about the osmosis-dev mailing list