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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
