[OSM-dev] Postgres 8.4 performance trouble in osm2pgsql setup

Pieren pieren3 at gmail.com
Wed May 12 01:09:06 BST 2010

On Sat, May 8, 2010 at 1:11 AM, Frederik Ramm <frederik at remote.org> wrote:

> The intial import went all right on 8.3 and 8.4; my "4 times slower" was
> about adding a daily diff to the data base.
Just for information, I also compared the performance on my Ubuntu 10.04
Lucid, amd64 distrib (ext4, hdd raid0 10k rpm) and I got the following
My country new import:
8.4: 33mn07
8.3: 32mn46

Daily diff import:
8.4: 43mn40
8.3: 26mn09
I don't have your factor 4 but 1.6x slower with postgresql 8.4.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100512/e92c101e/attachment.html>

More information about the dev mailing list