On 09/06/11 20:08, Oleksiy Karpenko wrote:

Hi,

How can I obtain various statistics on an existing index in the
database? For example, number of levels, average MBR size by each
dimension, and so on?

If you wish to start looking at the R-Tree structure then I would start by looking at Oleg and Teodor's gevel utility:

http://www.sai.msu.su/~megera/postgres/gist/

One day we should probably think about adding something like this into the main codebase...


HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to