Re: Cube Index Size - Mailing list pgsql-hackers

From Nick Raj
Subject Re: Cube Index Size
Date
Msg-id BANLkTimn2oscaMXWyZuTR8+qk=gOdQOAGw@mail.gmail.com
Whole thread Raw
In response to Re: Cube Index Size  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers


2011/6/2 Teodor Sigaev <teodor@sigaev.ru>
Can we figure out some information about index i.e. whet is the height
of index tree, how many values are placed in one leaf node and one non
leaf level node?

http://www.sigaev.ru/cvsweb/cvsweb.cgi/gevel/

For improving space utilization, When node is splitted, then we have to assign enteries to two groups. Once, one group is reached some threshod (m) then, insert the remaining entries into another group.

Can you suggest some way to choose 'm' (beacuse cube store in form of NDBOX that having variable length) or provide some guide with code?

Thanks 

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                  WWW: http://www.sigaev.ru/

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Next
From: Simon Riggs
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch