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.

On 9/24/2010 7:06 AM, Brett Henderson wrote:
Which osmosis task are you using to do the import? Is this the --write-pgsql-dump task? Building a full pgsql "simple" database with full planet will take very approximately one week of processing and 3-400GB of disk space ... I think. But it depends hugely on the hardware in particular the disk performance, and also which optional geometry columns you've added to the ways table. The import itself is relatively fast, but building indexes and running CLUSTER statements takes *much* longer.

If you're referring to the apidb database then I don't have any numbers. It's been a couple of years since I've tried that.

On Fri, Sep 24, 2010 at 1:06 AM, Nakor <[email protected] <mailto:[email protected]>> wrote:

       Hello,

    I was wondering what kind of performance people get when importing
    the whole planet using osmosis and what size is the final database.

    The import I am running has been going on for 3 days and the DB is
    now just over 100 Gb and growing. I was just wondering when I can
    expect it to finish.

     Thanks,

    N.

    _______________________________________________
    osmosis-dev mailing list
    [email protected] <mailto:[email protected]>
    http://lists.openstreetmap.org/listinfo/osmosis-dev



_______________________________________________
osmosis-dev mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/osmosis-dev

Reply via email to