[OSM-dev] Clustering geom Index of rendering DB

Kolossos tim.alder at s2002.tu-chemnitz.de
Wed Jul 6 19:00:08 BST 2011


Hello,
to optimize the rendering performance on Toolserver we talk about to 
clustering the geom index[1] of the 3 important database tables.

So I have some questions to that:
*What are the experiences with it at osm.org (before the replacement of 
the hard-disks by SSD)?
*How long will it estimated need?
*Whats a good time span for reclustering?
*Whats a good value for FillFactor [2]? Is it necessary to think about?

Thanks and
Greetings Kolossos


[1]http://postgis.refractions.net/documentation/manual-1.3/ch05.html#id2574260

[2]http://www.postgresonline.com/journal/index.php?/archives/10-How-does-CLUSTER-ON-improve-index-performance.html




More information about the dev mailing list