Skip site navigation (1) Skip section navigation (2)

Re: Index Size

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Nick Raj <nickrajjain(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Index Size
Date: 2011-05-30 23:23:41
Message-ID: 4DE426FD.6070103@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-general
On 05/30/2011 08:53 PM, Nick Raj wrote:
> Hi,
>
> 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

- A .sql file that demonstrated the problem,
   including your table definitions and index
   creation commands.

--
Craig Ringer

In response to

Responses

pgsql-general by date

Next:From: Craig RingerDate: 2011-05-30 23:35:53
Subject: Re: deadlock problem
Previous:From: Craig RingerDate: 2011-05-30 23:20:44
Subject: Re: Universal certificate for verify-full ssl connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group