[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