From: | Nick Raj <nickrajjain(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Index Size |
Date: | 2011-05-31 03:33:39 |
Message-ID: | BANLkTikanBd9qWx8Xccgi7foLifUCNifxQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 31, 2011 at 8:50 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Craig Ringer <craig(at)postnewspapers(dot)com(dot)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 <rhaas(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2011-05-31 04:09:18 | Re: trigger - dynamic WHERE clause |
Previous Message | Toby Corkindale | 2011-05-31 03:20:40 | Re: Shared Buffer Size |