On Tue, Sep 28, 2010 at 10:25 AM, Nakor <[email protected]> wrote: > On 09/24/2010 09:52 AM, Nakor wrote: > >> Brett, >> >> I should have read the whole documentation first. I am using --write-pgsql >> . I'll let it continue (as I am now over 200 Gb) and see how it goes. Next >> time I need to import I will probably just import the US vs the whole >> planet. Thanks for your input it gives a rough idea. >> >> Thanks, >> >> N. >> >> > It finished in 7 days and 17hours. The DB is 260Gb. Note that some speed > loss is probably due to the fact that the only disk where I had space to > store the DB is encrypted. >
Okay, cool. Which version of the schema are you using? Is it the version 5 schema that comes with Osmosis 0.36, or the version 6 schema that comes with Osmosis 0.37-SNAPSHOT? The version 6 schema takes much longer to import if you have the optional bbox or linestring columns on the ways table, but the query performance is much improved due to table CLUSTERing. Brett
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
