Hi Sven, On Thursday 28 April 2011, Sven Geggus wrote: > Disk speed can not be the Problem as I'm using a 2-Disk lvm on SSD here.
Is the data organization on the LVM comparable to a RAID-0 ? > The initial import is very fast (with pbf) and still fast (with .osm.bz2). > It is just updates which are very slow here. On a 3 disk RAID-0 I manage to import 30 hours within 24 hours. Same Linux, Software-Versions etc. > Two differences to the standard setup are a hstore column and that my > database is using lat/long instead of sperical mercator. Is this an advantage? Speedwise? > The Machine I'm using is quite fast (8 cores) and should have enough RAM > (32GB). I have a quad here, CPU load is not an issue; but just 8 GB of RAM. I looked at disk usage with iostat (-X) and harddisk utilization. On a one disk setup i got 100% at all time; no it is some where between 30-70% on each RAID disk. > Here is what postgresql.conf looks like: Don't have the config at hand till monday; but I recall, that the proportions on the mem are the same. > I still suspect that there is some setting here which I should change to > speed this up. For some strange reason it would currently be fastest to use > complete reimports of the planet rather that updates :( I am hoping so as well, also to get the HDD usage over the entire RAID up to 100%... Greetz, Markus
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev