[OSM-dev] speeding up loading an OSM dump into PostGIS?
frederik at remote.org
Thu Dec 15 11:10:13 GMT 2011
On 12/09/2011 02:11 AM, fatzopilot wrote:
> Well, I wonder why there isn't a feasible to do this with Postgres
> replication yet.
I think this is simply because it is not feasible. It is difficult
enough to keep replication going over unreliable connections but the
initial setup is guaranteed to be a nightmare.
Also, you would lose any chance of customising your instance (e.g.
importing different tags etc.). I really don't think there is anything
good about the idea.
This whole idea moves hardware requirements away from clients and
towards the central infrastructure - which means higher costs at the
core. I think that distributing the load rather than concentrating it is
good, and the replication idea seems to be the wrong way round!
But: Anyone who really wants to, and has the resources to, can set up a
full database today, feed it with minutely diffs through Osmosis, and
allow a merry band of replication clients down the line.
More information about the dev