[OSM-dev] API: no BBOX download of a way if no nodes inside the BBOX?

Frederik Ramm frederik at remote.org
Sun Apr 26 23:10:39 BST 2009


Hi,

Matt Amos wrote:
> On Sun, Apr 26, 2009 at 9:16 PM, Frederik Ramm <frederik at remote.org> 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 frederik at remote.org  ##  N49°00'09" E008°23'33"




More information about the dev mailing list