[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:

I found that increasing the maintenance_work_mem to several GB helped
the performance during the GIN index creation.


More information about the dev mailing list