[OSM-dev] minute diff - max delay
brett at bretth.com
Mon Sep 13 02:50:11 BST 2010
On Sun, Sep 12, 2010 at 9:28 PM, Brett Henderson <brett at bretth.com> wrote:
> I've just upgraded Osmosis from the 0.35 release to the current 0.37
> snapshot. I've introduced a relatively minor change that on initial testing
> appears to have fixed the problem. I create a number of temp tables during
> replication processing to hold identifiers (actually id and version) of each
> of nodes, ways and relations. I am now adding a primary key to those tables
> which should assist the query planner come up with a more effective query
> plan. I'm not sure why I didn't do that originally ... perhaps I just
> missed it.
> I'm a bit surprised that it has fixed it given that the amount of data in
> the temp tables is relatively small and query analysis wasn't pointing at
> poor query plans, but it seems to be running *much* faster now.
> The new version took effect from replication number 906 onwards, so if
> anybody sees any issues please let me know.
I haven't seen a single cron failure since the new version was deployed so
it's looking good so far. Previously almost 2 out of 3 minute jobs were
failing due to the previous job not completing in time. Even before the db
upgrade I used to get occasional failures. Such a simple change ... if only
I'd discovered it sooner.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev