Re: [OSM-talk] OSM import stats

2012-12-17 Thread Brian DeRocher
Stats posted http://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks#Planet_import_on_custom_server_VM_.2810_cores.2C_16_GB.2C_RAID5.29 -- Brian DeRocher http://brian.derocher.org http://mappingdc.org http://about.me/brian.derocher ___ talk mailing l

Re: [OSM-talk] OSM import stats

2012-12-17 Thread Martin Koppenhoefer
2012/12/17 Simon Poole : > Brian, the wiki page is here: > http://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks > > 6.6 days seems to be very long though. comparing with the times I usually get (more than a week, no raid, 7200sata disk, 8GB RAM) it is not so long. When you look at older result

Re: [OSM-talk] OSM import stats

2012-12-17 Thread Brian DeRocher
This is with clustering. That is to say it ran queries like this: create table foo_temp as select * from foo order by way; But i did not see something like this: cluster foo; I see now from PG 9.1 documention that CLUSTER is a one-time operation. So it's effectively the same thing. I

Re: [OSM-talk] OSM import stats

2012-12-17 Thread Martijn van Exel
With 3 5400 RPM drives in a RAID 5 I am surprised that it didn't take longer. Is this with or without table clustering? Or does osm2pgsql not include that as part of the process (as the default osmosis load script does)? On Mon, Dec 17, 2012 at 10:55 AM, Simon Poole wrote: > Am 17.12.2012 16:19,

Re: [OSM-talk] OSM import stats

2012-12-17 Thread Simon Poole
Am 17.12.2012 16:19, schrieb Brian DeRocher: Frederick and all, I found your SotM presentations on OSM imports regarding disks and stats.I just completed a full planet import via osm2pgsql. Are you interested in the stats from my import? I *think* there's a wiki page about import stats,

Re: [OSM-talk] OSM import stats

2012-12-17 Thread Shaun McDonald
The wiki page you are looking for is: http://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks It's worth mentioning on there the other settings that you had used. Shaun On 17 Dec 2012, at 15:19, Brian DeRocher wrote: > Frederick and all, > > I found your SotM presentations on OSM imports reg

[OSM-talk] OSM import stats

2012-12-17 Thread Brian DeRocher
Frederick and all, I found your SotM presentations on OSM imports regarding disks and stats.I just completed a full planet import via osm2pgsql. Are you interested in the stats from my import? I *think* there's a wiki page about import stats, should i put them there. Long story short: 3