Hi, Matt Amos wrote: > On Sun, Apr 26, 2009 at 9:16 PM, Frederik Ramm <[email protected]> wrote: >> I think it would be promising to set up a daily/hourly/minutely diff >> based API mirror outside of the OSM empire that uses proper PostGIS >> geometries so we could do performance comparisons. > > i did a simple performance comparison of our tile-based btree node > lookup versus a proper postgis r-tree. the r-tree was twice as slow.
It is possible that these effects would be offset by PostGIS being able to include way geometries in the index, thus allowing us to drop the node->way indirection we currently employ. It is of course equally possible that this is even slower. Bye Frederik -- Frederik Ramm ## eMail [email protected] ## N49°00'09" E008°23'33" _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
