|
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? |
|
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. Meanwhile PostgreSQL 9.1 is available
(17 Jan '12, 13:02)
saerdnaer
|
|
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. |
