[OSM-dev] [OSM-newbies] Should osm2pgsql create the planet_osm tables?

[John Wheeler]

Patience seems indeed to be the key  ;-) I managed to get the data into my
gis database on ubunty gutsy in a vmware vm.  Don't try this at home with
kids wanting to play games! My next step is getting Mapnik compiled. Thanks
for the info guys.

John

On Jan 22, 2008 8:03 PM, Jon Burgess <jburgess777 at googlemail.com> wrote:

>
> On Tue, 2008-01-22 at 11:11 +0000, Dave Stubbs wrote:
> > I think this is effectively what it's doing (it uses a postgres COPY
> > statement too). Unfortunately there are about 10 million ways in the
> > DB being added to GIST index, and it takes a while on my box as
> > there's only 1GB RAM.
> >
> > I haven't looked at that part of the code in much detail either... I'm
> > guessing it isn't doing anything particularly silly though, and before
> > the tiger import it worked in a very reasonable amount of time.
> >
> Artem suggest I add a bounding box option to filter the planet during
> the import. This would help make things a lot faster if you only want a
> subset of the data. I've added it to my TODO list.
>
>        Jon
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20080124/a2f3cfed/attachment.html>