walkermatt · August 29, 2015 14:04
diff --git a/loader_parallel.sh b/loader_parallel.sh
 find /var/data/osmm/ -type f -print0 | \
 parallel -0 python loader.py loader.config "src_dir={}"
diff --git a/natural_earth_loop.sh b/natural_earth_loop.sh
 time for FILE in `find . -name '*.shp' -not -path "./tools/*"`; do \
    BASE=`basename $FILE .shp`; \
    shp2pgsql -W LATIN1 -s 4326 -I $FILE world.$BASE \
    | psql; done

 real	6m14.569s
diff --git a/natural_earth_parallel.sh b/natural_earth_parallel.sh
 time find . -name '*.shp' -not -path "./tools/*" \
     | parallel "shp2pgsql -W LATIN1 -s 4326 -I {} world.{/.} | psql"

 real	3m11.030s
	find /var/data/osmm/ -type f -print0 \| \
	parallel -0 python loader.py loader.config "src_dir={}"
	time for FILE in `find . -name '.shp' -not -path "./tools/"`; do \
	BASE=`basename $FILE .shp`; \
	shp2pgsql -W LATIN1 -s 4326 -I $FILE world.$BASE \
	\| psql; done

	real 6m14.569s
	time find . -name '.shp' -not -path "./tools/" \
	\| parallel "shp2pgsql -W LATIN1 -s 4326 -I {} world.{/.} \| psql"

	real 3m11.030s