Re: Index Size

Поиск
Список
Период
Сортировка
От Nick Raj
Тема Re: Index Size
Дата
Msg-id BANLkTikanBd9qWx8Xccgi7foLifUCNifxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index Size  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения


On Tue, May 31, 2011 at 8:50 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Craig Ringer <craig@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 <rhaas@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

В списке pgsql-general по дате отправления: