You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

#1 2021-07-27 16:54:06

jmelvin
Member
Registered: 2021-06-29
Posts: 14

Apply minutely diffs performance

How long does it generally take to download and apply 1 minutely diff?  Is it longer than a minute?  smile

Running apply_osc_to_db.sh, I see output that does not include the update ID...

Reading XML file ... finished reading nodes. Flushing to database ...... done.
Reading XML file ... finished reading ways. Flushing to database ...... done.
Reading XML file ... finished reading relations. Flushing to database ....... done.
Update complete.

This takes wayyyyy longer than 1 minute.  More like ~10 mins.  Might this script be combining minutely diffs and applying more than 1 at a time? 

Is there a technical reason the update ID is not displayed?

Offline

#2 2021-07-29 08:17:56

mmd
Member
Registered: 2010-11-06
Posts: 2,150

Re: Apply minutely diffs performance

The script can combine multiple diffs in one run. Check apply_osc_to_db.log file contents, it's telling you the exact diffs that are being processed (updating from ... updating to   ----> update complete) along with the respective timestamps.

Overall performance may depend on a number of factors. SSD is mandatory these days.

Offline

Board footer

Powered by FluxBB