[Tile-serving] [osm2pgsql] Replace manually allocated strings in middle-pgsql with std::string (#248)

[Paul Norman]

Hardware: i7-4700, 32GB RAM, 2x240GB SSD in RAID0
import command line: `osm2pgsql/osm2pgsql --create --style osm2pgsql/default.style --flat-nodes flat.nodes --cache 20000 --slim --number-processes 8 planet-130904.osm.pbf`
Update command line: ``sudo ./free_mem.sh && time (for n in `seq N1 N2`; do echo $n && osmosis/bin/osmosis --rxc  "diffs/008/$n.osc.gz" --simc --wxc - | osm2pgsql/osm2pgsql -d gis -a -S osm2pgsql/default.style --flat-nodes flat.nodes -C 2000 --slim --number-processes 1 - && sleep 10; done)``

(N1,N2) = (555,575), (576,595), (596,615), (616,635)

Time
```
version      master  std::string
proc n          895          896
proc w         4532         5226
proc r         7611         7566
pend w         3812         3812
index         21753        20213
total import  38753        37870
total update  14575        14252
```

Update time does not include `sleep 10` time and is a total of 81 hours of diffs.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/248#issuecomment-70310317
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150116/97ef2226/attachment.html>