On 09/27/2010 08:42 PM, Brett Henderson wrote:
On Tue, Sep 28, 2010 at 10:25 AM, Nakor <[email protected]
<mailto:[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
I am using 0.36 and have the bbox column activated.
BTW is there a way to migrate an existing DB from a schema version to
another or is the only route re-importing the whole base?
Also what is the benefit of the linestring column?
N.
_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev
