On Mon, Sep 20, 2010 at 10:43 PM, [email protected] < [email protected]> wrote:
> Hi , > i'm new of this mailing-list. I'd like to solve a problem with osmosis. > I try to use osmosis --repa option use with osmosi -rri option to > "replicate" > minutely update in my test server. > I try to instert into postgresql database a new node (POI) with JOSM and > run > osmosis --repa. I note that it takes about 5 minute for create an osc file > with > just my new node. > I think it il too slow. I used a osmsosi version 0.32 and 0.35. There is a > new > version of osmisi can solve this type of problem? > Thanks to all. > Try the apidb_0.6_osmosis_xid_indexing.sql script provided with Osmosis. It adds indexing necessary to query for transaction ids efficiently. Without the indexes you'll be doing full table scans. It also adds a function called xid_to_int4 which is implemented in plpgsql. The production database uses an equivalent function written in C, but it shouldn't make much difference to performance.
_______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
