[Geocoding] Nominatim SQL script indexing speed

[Teemu Ikonen]

Hi,

I did few experiments with latest Nominatim sql scripts and for some
reason the indexing is very, very slow. The gazetteer-loaddata.sql
progresses maybe 0.5 - 2GB per 24h (as reported by  select
pg_size_pretty(pg_relation_size('placex'));

Few facts
- Indexing seems to be CPU bound, faster or slower IO setup does not
make significant difference
- Same results with Ubuntu 10.40 / Postgres 9.0 / PostGIS 1.5.2  and
Fedora core 8 / Postgres 8.3 / PostGIS 1.5.1
- Version: http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer,
Revision: 24892
- "HW" is Amazon EC2 m1.xlarge instance.

Last time I did this was on osm2pgsql SVN Revision: 22731, the
loaddata step took ~24 hours on Postgres 8.3. Now, loaddata probably
takes 10-40 days if it ever finishes.

Br Teemu