[OSM-dev] Lite OSM backend

Nick Hill nick at nickhill.co.uk
Sun Sep 10 00:25:56 BST 2006


Hello Niko

I have performed tests on node data types under R-tree indexes with 
simulated load as well as B-tree.

The R-tree index implementation which I tried for node data type caused 
a large number of  page faults requiring big disc seeks. From my tests, 
I predict B-tree segmented indexes will give the overall best 
performance for point/node data types.

I would like to see a move towards an R-tree index and spatial data 
types for polygons to make polygon inheritance possible/efficient.



Nicola Ranaldo wrote:
>> you've missed some things in the document, such as:
>>
>> http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html
> 
> you are right, but i think it's not close-related to table clustering on 
> indexes... howewer rereading postgresql documentation i found a very 
> interesting thing:  
> http://www.postgresql.org/docs/8.0/static/sql-cluster.htm .
> I'll test it and report results (as i do not know if it's good on spacial - 
> rtree- index too). Someone using mysql could verify if is there a similiar 
> feature and test it?
> 
> 	Niko
> 




More information about the dev mailing list