[OSM-dev] Importing planet file with osmosis into PostgreSQL
Jon Burgess
jburgess777 at googlemail.com
Sun Dec 13 13:03:17 GMT 2009
On Sun, 2009-12-13 at 12:41 +0000, Shaun McDonald wrote:
> There are some additional hints on the following wiki page:
> http://wiki.openstreetmap.org/wiki/Mapnik#Loading_Data
>
> I'm sure other people on the list will be able to add more than me on tuning postgres. You should expect it to take a day or two to load if the disks are slow. There are a few discussions in the archives that may be of some help to you.
>
> Shaun
The more interesting link is:
http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS#Tuning_the_database
I found that increasing the maintenance_work_mem to several GB helped
the performance during the GIN index creation.
Jon
More information about the dev
mailing list