Pre-Filter and rebuild of current tables
|Reported by:||MikeyCarter||Owned by:||brett@…|
This is somewhat of a dual ticket, one problem is creating the second situation.
I've loaded all of Ontario, Canada, but have been pulling in all updates from replication so after 1 1/2 years of data I've got most of the world.
If I want to pull just Ontario data it seems to query the entire world, then filter. It would be nice to have the filter applied at the sql read level so it doesn't have to read the entire database.
The second part to this ticket, my current work-a-round is to delete all but Canada from the current_* tables, that way I'm not pulling the world before the prefilter. That way I have a much smaller set to work from. (while the history is still intact in the other tables)
However, would be nice if there was a way osmosis could rebuild the current_* tables. (in part or as a whole) That way every once and a while I could apply the province filters to osmosis and rebuild.