[OSM-dev] osm2pgsql deltas

[Steve Hill]

On Tue, 19 Jan 2010, Martijn van Oosterhout wrote:

> That seems awfully long.

It seems to match what other people have reported here.

> You did tune postgresql as described in the
> wiki before you started, right?

Yep.

> You did make sure you actually had
> enough memory to make sure you aren't swapping in the process?

8GB of RAM.

> On a
> system with only 1GB of memory I could get it to complete in a day
> (though that was a while back)..

Were you using slim mode?  I can import in under a day when not using slim 
mode, however you have to use slim mode if you want to be able to apply 
deltas and this adds a huge overhead.

-- 

  - Steve
    xmpp:steve at nexusuk.org   sip:steve at nexusuk.org   http://www.nexusuk.org/

      Servatis a periculum, servatis a maleficum - Whisper, Evanescence