Hi Brian, > I'd suggest you uncomment the 'RAISE WARNING '%',NEW.osm_id;' line at > the top of placex_insert in gazetteer-functions.sql so you can follow > the progress of the insert.
I did this and it appears to be inserting about 100-200 rows per second (eyeballing it). The problem appears to be that my RAM usage is increasing on the postgres process by about 2-4MB per second and never released. This causes things to eventually use swap space, slow and crash. Just in case it adds some info the following are the postgresql.conf settings I've changed: 107c107 < shared_buffers = 32MB # min 128kB or max_connections*16kB --- > shared_buffers = 128MB # min 128kB or > max_connections*16kB 115c115 < #maintenance_work_mem = 16MB # min 1MB --- > maintenance_work_mem = 256MB # min 1MB 171c171 < #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each --- > checkpoint_segments = 20 # in logfile segments, min 1, 16MB each > You could also try uncomment the RETURN NEW; just before the line 'The > following is not needed until doing diff updates, and slows the main > index process down' to see if that has an effect. This doesn't appear to have much of an impact. :( What version of Linux/PostgreSQL are you using? I haven't seen much on the wiki about CentOS so I'm wondering if there is a version problem, or I'm missing a package or something. It may be worth trying a fresh install on a virtual machine to see if I'm simply missing something. Thanks! -jason _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
