[OSM-dev] Inefficient R-tree in PostGIS

Jochen Topf jochen at remote.org
Sat Aug 7 09:01:24 BST 2010


Hi!

Paul Ramsey just mentioned [1] two interesting blog posts [2, 3] about
possible inefficiencies in the R-tree implemention of PostGIS. Could be a
reason why OSM rendering of tiles is slower that it should be.

[1] http://blog.cleverelephant.ca/2010/08/take-this-tree-and-pack-it.html
[2] http://cognitivelychris.blogspot.com/2008/10/nitpicking-pick-split.html
[3] http://cognitivelychris.blogspot.com/2009/09/send-your-r-trees-packing.html

Jochen
-- 
Jochen Topf  jochen at remote.org  http://www.remote.org/jochen/  +49-721-388298




More information about the dev mailing list