NOTICE: is being shutdown on 1st March 2024. Please use the OpenStreetMap Community Forum


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%20Allan's gravatar image

Andy Allan
accept rate: 28%

edited 06 Jul '10, 17:21

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.

permanent link

answered 10 Jul '10, 16:53

TomH's gravatar image

TomH ♦♦
accept rate: 20%

edited 10 Sep '10, 08:36

Jonathan%20Bennett's gravatar image

Jonathan Ben...

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.

permanent link

answered 06 Jul '10, 17:40

twain's gravatar image

accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 25 Jun '10, 16:34

question was seen: 10,218 times

last updated: 17 Jan '12, 13:02

NOTICE: is being shutdown on 1st March 2024. Please use the OpenStreetMap Community Forum