[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