[Geocoding] osm2pgsql / Gazetteer import errors

[Andy Allan]

On Mon, Jan 4, 2010 at 2:52 PM, Brian Quinion
<openstreetmap at brian.quinion.co.uk> wrote:

>> I started the process on a standard Amazon cloud 32-bit 1-Processor Fedora unit.
>
> Not any immediate problem but I'd guess due to the size of node IDs a
> 32 bit machine has a limited time left - I'd guess around 2 years.

So Amazon EC2 machines have stunningly dreadful disk performance. It's
a continual headache that I'm running the cyclemap on one (an
extra-large instance). I use "normal" mode for the cyclemap import,
but Matt used to use slim mode for his minutely tileserver and it
would take about a week to just run osm2pgsql (I'll let him correct me
if that's wrong). Although I haven't used the gazetteer import mode on
one, I can't imagine for a minute that it'll be in any way quick.

My advice would be to find another host other than EC2 if you are
doing anything involving osm2pgsql (or anything else that isn't
running in RAM).

Cheers,
Andy