[OSM-dev] osm2pgsql slow on update import

Sven Geggus lists at fuchsschwanzdomain.de
Mon May 2 14:32:19 BST 2011


Markus Wagner <markus at mwagner.info> wrote:

> Is the data organization on the LVM comparable to a RAID-0 ?

The Linux RAID driver does not support SATA TRIM, thats why I'm using lvm
here.

My setup is loosely based on this HOWTO:
http://www.ocztechnologyforum.com/forum/archive/index.php/t-82648.html

So yes, this is more or less the same as Software RAID-0.

>> 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?

I did not change this on purpose, not for speed. Our database should be used
for other purposes than rendering (WFS) as well.

Sven

-- 
"Das ist halt der Unterschied: Unix ist ein Betriebssystem mit Tradition,
 die anderen sind einfach von sich aus unlogisch."
                          (Anselm Lingnau in de.comp.os.unix.discussion)
/me ist giggls at ircnet, http://sven.gegg.us/ im WWW



More information about the dev mailing list