[osmosis-dev] Improved PostGIS Load Task

David Carmean dlc at halibut.com
Fri May 21 18:32:52 BST 2010


On Mon, May 17, 2010 at 09:13:16PM +1000, Brett Henderson wrote:
> 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.


Keep the dump, please.  I don't want to lose the ability to separate chunks of the 
workflow when I want/need to.






More information about the osmosis-dev mailing list