Using postgres 8.4 diff imports seem to run as slow as a license change. I've hear that it's better to use postgres 8.3. Is there any other way? asked 25 Jun '10, 16:34  Andy Allan edited 06 Jul '10, 17:21 |
2 Answers:
Frederik Ramm mentioned this in his SOTM10 presentation and he has had a chance to try Postgres 9.0 (with Postgis 1.5) and that apparently no longer suffers from this slowdown - in fact it is apparently faster than Postgres 8.3 in his benchmarks. answered 10 Jul '10, 16:53  TomH ♦♦ edited 10 Sep '10, 08:36  Jonathan Ben... |
The problems seem to relate to GIN index updates. In the case of osm2pgsql this seems to be particularly updates to planet_osm_ways_nodes, which is the index on the list of nodes for a way. Given the the imminent release of postgresql 9.0 it seems likely that this problem won't get resolved and will probably be reinvestigated once 9.0 is out. answered 06 Jul '10, 17:40  twain |
Meanwhile PostgreSQL 9.1 is available