[Tile-serving] [osm2pgsql] Very low performace on adding diff-s (#343)

[jendrusk]

I'm having some trouble with adding diffs generated by osmosis and appreciate any help...

My first import was on good performance:

Processing: Node(1298k 14.9k/s) Way(148k 0.90k/s) Relation(6747 137.69/s)  parse time: 301s

But next which start 10 minutes after this one ended next run (and all after it) is in very low performance:

Processing: Node(1052k 0.4k/s) Way(137k 0.11k/s) Relation(4134 60.79/s)  parse time: 3652s

What is most confusing - I didn't change any of database parameters, there was no database restart between them and seems like nothing have changed in enviroment (or I forgot sth).

Maybe someone know this problem or have any idea what is causing it ?
Maybe there is some way to debug it (except working on code - I'm not developer) ?

Any help appreciated (ple, ple, pleeeezzzzzz)

PS. I fallowed the issue #163 with large shared buffers and there is little better but still far from first run:

Processing: Node(198k 1.2k/s) Way(15k 0.31k/s) Relation(406 81.20/s)  parse time: 220s

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/343
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150424/e0e88704/attachment.html>