| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | Nick Raj <nickrajjain(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Index Size |
| Date: | 2011-05-31 03:20:40 |
| Message-ID: | 16119.1306812040@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Raj | 2011-05-31 03:33:39 | Re: Index Size |
| Previous Message | Tom Lane | 2011-05-31 03:09:45 | Re: Function Column Expansion Causes Inserts To Fail |