size of data stored in gist index

From: Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: size of data stored in gist index
Date: 2009-07-31 16:12:44
Message-ID: 20090731161244.GB3523@gheift.kawo1.rwth-aachen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I try to index histograms in my table. For this I uses the cube contrib
module in which I removed the dimension check. If the cube has more than
255 dimensions, for example 256 ^= 4 + 4 + 256 * 2 * 8 = 4104 bytes, this
data can not be stored in the gist index any more. If I try it, I get the
following error:

PANIC: failed to add item to index page in "histogram_idx"

Do I have to compress the data in any way or is it possible, to store index
data with this huge size?

Thanks,
Gerhard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-07-31 16:15:50 Re: Grouping Question
Previous Message Raymond O'Donnell 2009-07-31 16:12:02 Re: export csv file on XP