NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

1
1

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
12.5k23128153
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 ♦♦
3.3k83943
accept rate: 20%

edited 10 Sep '10, 08:36

Jonathan%20Bennett's gravatar image

Jonathan Ben...
8.3k1785108

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

twain
2.4k2538
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×440
×263
×34
×32

question asked: 25 Jun '10, 16:34

question was seen: 10,260 times

last updated: 17 Jan '12, 13:02

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum