[OSM-dev] having a regularly updated OSM database?
andrzej zaborowski
balrogg at gmail.com
Wed Apr 11 14:22:27 BST 2012
On 11 April 2012 08:51, Paul Norman <penorman at mac.com> wrote:
>> -----Original Message-----
>> From: Ákos Maróy [mailto:akos at maroy.hu]
>> Sent: Tuesday, April 10, 2012 11:22 PM
>> To: dev at openstreetmap.org
>> Subject: [OSM-dev] having a regularly updated OSM database?
>>
>> Hi,
>>
>> I wonder what is the best way to have a regularly updated, up-to-date
>> OSM database? By regularly, I mean an update about say once a month.
>
> It depends what you want to do with the data. There's pgsnapshot databases,
> osm2pgsql databases, apidb databases and plenty of others.
>
>> Previously I experimented with osm2pgsql, but that took me 5 days to
>> import, and the 'update' process was on the same order of magnitude.
>> (this is on an i7 3.2GHz system with 12GB RAM).
>
> I expect this is limited by your disks, not by your CPU.
>
>> Is there any way that allows for faster updates down the line?
>
> If you're updating it may be easier to keep it continually up to date with
> minutely replication diffs.
But note that on usual hardware (the type that takes 5 days to import
the planet), applying replication diffs can take more than 2/3rds of
the time, which is ~3 weeks per month summed.
Cheers
More information about the dev
mailing list