[Tile-serving] [openstreetmap/osm2pgsql] Introduce separate COPY threads (#914)

[Paul Norman]

With master and luajit
```
Processing: Node(5043406k 4137.3k/s) Way(563353k 40.39k/s) Relation(6601440 1005.55/s)  parse time: 21733s
Node stats: total(5043406477), max(6285198313) in 1219s
Way stats: total(563353404), max(671171896) in 13949s
Relation stats: total(6602164), max(9334518) in 6565s
Committing transaction for admin_area
Committing transaction for admin_line
Committing transaction for place_point
...
Mid: removing persistent node cache at nodes.bin
node cache: stored: 5043406477(100.00%), storage efficiency: 83.12% (dense blocks: 694886, sparse nodes: 187737901), hit rate: 100.00%
Osm2pgsql failed due to ERROR: Connection to database failed: FATAL:  sorry, too many clients already
```

with b89aea3 and no luajit
```
Processing: Node(5043406k 2688.4k/s) Way(563353k 25.76k/s) Relation(6601590 979.76/s)  parse time: 30484s
Node stats: total(5043406477), max(6285198313) in 1876s
Way stats: total(563353404), max(671171896) in 21870s
Relation stats: total(6602164), max(9334518) in 6738s
Mid: removing persistent node cache at nodes.bin
node cache: stored: 5043406477(100.00%), storage efficiency: 83.12% (dense blocks: 694886, sparse nodes: 187737901), hit rate: 100.00%
Osm2pgsql failed due to ERROR: Connection to database failed: FATAL:  sorry, too many clients already
```

I'm rerunning with luajit, I forgot to enable it when building the branch

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/914#issuecomment-468946296
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20190302/d04a3e33/attachment.html>