On Tue, May 31, 2011 at 8:50 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Craig Ringer <cr...@postnewspapers.com.au> writes: > > On 05/30/2011 08:53 PM, Nick Raj wrote: > >> Cube code provided by postgres contrib folder. It uses the NDBOX > structure. > >> On creating index, it's size increase at a high rate. > > > [snip] > > >> Can some one tell me why index is becoming so large? > >> How to compress or reduce its size? > > > It'd help if you included some more details: > > > - Your PostgreSQL version > > In particular, I wonder whether his version contains this fix: > > Author: Robert Haas <rh...@postgresql.org> > Branch: master [4fa0a23c7] 2010-11-14 21:27:34 -0500 > Branch: REL9_0_STABLE Release: REL9_0_2 [e6b380251] 2010-11-14 21:27:34 > -0500 > Branch: REL8_4_STABLE Release: REL8_4_6 [2519b8268] 2010-11-14 21:27:34 > -0500 > Branch: REL8_3_STABLE Release: REL8_3_13 [d589e4070] 2010-11-14 21:27:34 > -0500 > Branch: REL8_2_STABLE Release: REL8_2_19 [e642ca767] 2010-11-14 21:27:34 > -0500 > Branch: REL8_1_STABLE Release: REL8_1_23 [0e27a7319] 2010-11-14 21:27:34 > -0500 > > Fix bug in cube picksplit algorithm. > > Alexander Korotkov > > > Is this bug fixed? postgresql 9.0 having this bug or not? Thanks