[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